<report xmlns="http://developer.cognos.com/schemas/report/12.0/" expressionLocale="en-us" useStyleVersion="10"><!--RSU-SPC-0093 The report specification was upgraded from "http://developer.cognos.com/schemas/report/11.0/" to "http://developer.cognos.com/schemas/report/12.0/" at 2016-3-30. 16:23:32-->
				<modelPath>/content/folder[@name='Packages']/package[@name='Storage and Storage Pool Capacity']/model[@name='model']</modelPath>
				<drillBehavior modelBasedDrillThru="true"/>
				
				<layouts>
					<layout>
						<reportPages>
							<page name="Page1"><style><defaultStyles><defaultStyle refStyle="pg"/></defaultStyles><CSS value="width:1400px"/></style>
								<pageBody><style><defaultStyles><defaultStyle refStyle="pb"/></defaultStyles></style>
									<contents>
										
									<HTMLItem>
			<dataSource>
				<staticValue>&lt;style&gt; #headerBack { display: none; } .mainHeader1 { display: none; } .mainViewerHeader3 { display: none; } &lt;/style&gt;</staticValue>
			</dataSource>
		</HTMLItem><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:1450px"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered by OnCommand Insight</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:white"/></style></textItem></contents><style><CSS value="height:24px;background-color:#6198C5;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Chargeback</staticValue></dataSource></textItem></contents><style><CSS value="height:36px;padding-left:10px;font-family:Arial;font-size:24px;color:#333333;background-color:#FBFBFB;border-bottom:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Total Provisioned</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton1" refQuery="Chargeback Changes">
			<contents><textItem><dataSource><dataItemValue refDataItem="Total Provisioned (TB)"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###,### TB"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Total Provisioned Cost</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton2" refQuery="Chargeback Changes">
			<contents><textItem><dataSource><dataItemValue refDataItem="Total Provisioned Cost"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="$###,###.## M"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Physical Compute Storage Cost</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton6" refQuery="Chargeback Detail">
			<contents><textItem><dataSource><dataItemValue refDataItem="Physical Compute Cost"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="$###,###.## M"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Virtual Compute Storage Cost</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton7" refQuery="Chargeback Detail">
			<contents><textItem><dataSource><dataItemValue refDataItem="Virtual Compute Cost"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="$###,###.## M"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Windows Configured Cost</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton8" refQuery="Chargeback Detail">
			<contents><textItem><dataSource><dataItemValue refDataItem="Windows Configured Cost"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><currencyFormat decimalSize="0"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:1.5pt solid #ADB2B5"/></style></tableCell><tableCell><contents/></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Linux Configured Cost</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton9" refQuery="Chargeback Detail">
			<contents><textItem><dataSource><dataItemValue refDataItem="Linux Configured Cost"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><currencyFormat decimalSize="0"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:1.5pt solid #ADB2B5"/></style></tableCell><tableCell><contents/></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Cost per IOpS</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton5" refQuery="Cost per IOpS">
			<contents><textItem><dataSource><dataItemValue refDataItem="Cost per IOpS"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><currencyFormat decimalSize="0"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="background-color:#F7F7F7;padding-bottom:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Top Business Units</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(by Total Provisioned Costs)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" orientation="horizontal" refQuery="Top 5 Business Units" name="Combination Chart1" depth="9">
																																						<v2_combinationTypeTooltips/>
																																						
																																						<v2_commonAxis>
																																							<v2_ordinalAxis autoTruncation="false" truncationText="..." manualTruncationMaxChars="15">
																																								<v2_axisLabels>
																																									<style>
																																										<defaultStyles>
																																											<defaultStyle refStyle="al"/>
																																										</defaultStyles>
																																									<CSS value="color:#454545"/></style>
																																								</v2_axisLabels>
																																							</v2_ordinalAxis>
																																						<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Business Unit"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="Total Provisioned Cost"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																																						<v2_topLeftAxis>
																																							<v2_combinationChartTypes>
																																								<v2_bar borderColor="white" setOrdinalWidthScale="80" bevel="none" barShape="box">
																																									<v2_solidPalette>
																																				<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#FDCF9B"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Total Provisioned Cost"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
																																							</v2_combinationChartTypes>
																																							<v2_axis>
																																								<v2_axisRange>
																																									<v2_automaticRange/>
																																								</v2_axisRange>
																																								<v2_axisLabels>
																																			<style>
																																				<defaultStyles>
																																					<defaultStyle refStyle="al"/>
																																				</defaultStyles>
																																				<CSS value="color:#454545"/><dataFormat><numberFormat pattern="$###,### K"/></dataFormat></style>
																																		</v2_axisLabels><v2_majorGridlines lineColor="#EEEEF0" lineWeight="0"/></v2_axis>
																																						</v2_topLeftAxis>
																																						<style>
																																							<CSS value="width:445px;height:175px;color:#454545"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
																																						<noDataHandler>
																																							<contents>
																																								<block>
																																									<contents>
																																										<textItem>
																																											<dataSource>
																																												<staticValue>No Data Available</staticValue>
																																											</dataSource>
																																											<style>
																																												<CSS value="padding:10px 18px;"/>
																																											</style>
																																										</textItem>
																																									</contents>
																																								</block>
																																							</contents>
																																						</noDataHandler>
																																					</v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Top Applications</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(by Total Provisioned Costs)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" orientation="horizontal" refQuery="Top 5 Applications" name="Combination Chart2" depth="9">
																																						<v2_combinationTypeTooltips/>
																																						
																																						<v2_commonAxis>
																																							<v2_ordinalAxis autoTruncation="false" truncationText="..." manualTruncationMaxChars="15">
																																								<v2_axisLabels>
																																									<style>
																																										<defaultStyles>
																																											<defaultStyle refStyle="al"/>
																																										</defaultStyles>
																																									<CSS value="color:#454545"/></style>
																																								</v2_axisLabels>
																																							</v2_ordinalAxis>
																																						<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Application"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="Total Provisioned Cost"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																																						<v2_topLeftAxis>
																																							<v2_combinationChartTypes>
																																								<v2_bar borderColor="white" setOrdinalWidthScale="80" bevel="none" barShape="box">
																																									<v2_solidPalette>
																																				<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#FDCF9B"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Total Provisioned Cost"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
																																							</v2_combinationChartTypes>
																																							<v2_axis>
																																								<v2_axisRange>
																																									<v2_automaticRange/>
																																								</v2_axisRange>
																																								<v2_axisLabels>
																																			<style>
																																				<defaultStyles>
																																					<defaultStyle refStyle="al"/>
																																				</defaultStyles>
																																				<CSS value="color:#454545"/><dataFormat><numberFormat pattern="$###,### K"/></dataFormat></style>
																																		</v2_axisLabels><v2_majorGridlines lineColor="#EEEEF0" lineWeight="0"/></v2_axis>
																																						</v2_topLeftAxis>
																																						<style>
																																							<CSS value="width:445px;height:175px;color:#454545"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
																																						<noDataHandler>
																																							<contents>
																																								<block>
																																									<contents>
																																										<textItem>
																																											<dataSource>
																																												<staticValue>No Data Available</staticValue>
																																											</dataSource>
																																											<style>
																																												<CSS value="padding:10px 18px;"/>
																																											</style>
																																										</textItem>
																																									</contents>
																																								</block>
																																							</contents>
																																						</noDataHandler>
																																					</v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Top Hosts</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(by Total Provisioned Costs)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" orientation="horizontal" refQuery="Top 5 Hosts" name="Combination Chart3" depth="9">
																																						<v2_combinationTypeTooltips/>
																																						
																																						<v2_commonAxis>
																																							<v2_ordinalAxis autoTruncation="false" truncationText="..." manualTruncationMaxChars="15">
																																								<v2_axisLabels>
																																									<style>
																																										<defaultStyles>
																																											<defaultStyle refStyle="al"/>
																																										</defaultStyles>
																																									<CSS value="color:#454545"/></style>
																																								</v2_axisLabels>
																																							</v2_ordinalAxis>
																																						<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Host"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="Total Provisioned Cost"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																																						<v2_topLeftAxis>
																																							<v2_combinationChartTypes>
																																								<v2_bar borderColor="white" setOrdinalWidthScale="80" bevel="none" barShape="box">
																																									<v2_solidPalette>
																																				<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#FDCF9B"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Total Provisioned Cost"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
																																							</v2_combinationChartTypes>
																																							<v2_axis>
																																								<v2_axisRange scale="log">
																																									<v2_automaticRange sameRangeAllInstances="true" includeZeroForAutoScale="true"/>
																																								</v2_axisRange>
																																								<v2_axisLabels>
																																			<style>
																																				<defaultStyles>
																																					<defaultStyle refStyle="al"/>
																																				</defaultStyles>
																																				<CSS value="color:#454545"/><dataFormat><numberFormat pattern="$###,### K"/></dataFormat></style>
																																		</v2_axisLabels><v2_majorGridlines lineColor="#EEEEF0" lineWeight="0"/></v2_axis>
																																						</v2_topLeftAxis>
																																						<style>
																																							<CSS value="width:445px;height:175px;color:#454545"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
																																						<noDataHandler>
																																							<contents>
																																								<block>
																																									<contents>
																																										<textItem>
																																											<dataSource>
																																												<staticValue>No Data Available</staticValue>
																																											</dataSource>
																																											<style>
																																												<CSS value="padding:10px 18px;"/>
																																											</style>
																																										</textItem>
																																									</contents>
																																								</block>
																																							</contents>
																																						</noDataHandler>
																																					</v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px"/></style></tableCell><tableCell><contents/></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="height:10px;background-color:#F7F7F7;padding-right:10px;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Allocated Storage Cost Trends</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" name="Combination Chart7" refQuery="Chargeback Trending">
																				<v2_combinationTypeTooltips/>
																				<v2_commonAxis>
																					<v2_ordinalAxis>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/></style>
																						</v2_axisLabels>
																					</v2_ordinalAxis>
																					<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Date"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Date"/></dataSource></chartTextItem></chartContents><style><dataFormat><dateFormat pattern="yy/MM"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																				<v2_topLeftAxis>
																					<v2_combinationChartTypes>
																						<v2_line lineAreaShape="smooth" lineDisplayType="lineAndMarkers"><v2_linePalette markerBorderColor="white" markerBorders="show" markerSize="8px"><v2_linePaletteEntries><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#8599D3"><v2_solidColor color="#9ABCC3" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#8599D3"><v2_color color="#9ABCC3"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#E3AE6C"><v2_solidColor color="#A8E3D7" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#E3AE6C"><v2_color color="#A8E3D7"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry><v2_lineFill defaultColor="#198545"><v2_color color="#88B2D3"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry><v2_lineFill defaultColor="#198545"><v2_color color="#FFB2C1"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry></v2_linePaletteEntries></v2_linePalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Allocated Cost"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_line></v2_combinationChartTypes>
																					<v2_axis>
																						<v2_axisRange scale="linear">
																							
																						<v2_automaticRange sameRangeAllInstances="true" includeZeroForAutoScale="true"/></v2_axisRange>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/><dataFormat><numberFormat pattern="$###,### K"/></dataFormat></style>
																						</v2_axisLabels>
																						<v2_majorGridlines lineColor="#EEEEF0" lineWeight="0"/>
																					</v2_axis>
																				</v2_topLeftAxis>
																				<style>
																					<defaultStyles>
																						<defaultStyle refStyle="ch"/>
																					</defaultStyles>
																					<CSS value="width:445px;height:150px"/></style>
																				<noDataHandler>
																					<contents>
																						<block>
																							<contents>
																								<textItem>
																									<dataSource>
																										<staticValue>No Data Available</staticValue>
																									</dataSource>
																									<style>
																										<CSS value="padding:10px 18px;"/>
																									</style>
																								</textItem>
																							</contents>
																						</block>
																					</contents>
																				</noDataHandler>
																				<v2_legend>
																					<v2_legendPosition>
																						<v2_legendPreset legendPositionPreset="bottom"/>
																					</v2_legendPosition>
																					<style>
																						<defaultStyles>
																							<defaultStyle refStyle="lg"/>
																						</defaultStyles>
																					<CSS value="font-family:Arial;color:#454545"/></style>
																				</v2_legend>
																				<XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Host Costs by Configuration</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" refQuery="Chargeback Detail" name="Combination Chart4" depth="9">
																																<v2_combinationTypeTooltips/>
																																<v2_commonAxis>
																																	<v2_ordinalAxis autoTruncation="false" truncationText="..." manualTruncationMaxChars="15">
																																		<v2_axisLabels>
																																									<style>
																																										<defaultStyles>
																																											<defaultStyle refStyle="al"/>
																																										</defaultStyles>
																																									<CSS value="color:#454545"/></style>
																																								</v2_axisLabels></v2_ordinalAxis>
																																	<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="ConfiguredAs"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																																<v2_topLeftAxis>
																																	<v2_combinationChartTypes>
																																		<v2_bar borders="hide" borderColor="white" setOrdinalWidthScale="80" bevel="none" barShape="box">
																																			<v2_solidPalette>
																																				<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#FDCF9B"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Configured Cost"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
																																	</v2_combinationChartTypes>
																																	<v2_axis>
																																		<v2_axisRange>
																																			<v2_automaticRange/>
																																		</v2_axisRange>
																																		<v2_axisLabels>
																																			<style>
																																				<defaultStyles>
																																					<defaultStyle refStyle="al"/>
																																				</defaultStyles>
																																				<CSS value="color:#454545"/><dataFormat><numberFormat pattern="$###,### K"/></dataFormat></style>
																																		</v2_axisLabels><v2_majorGridlines lineColor="#EEEEF0" lineWeight="0"/></v2_axis>
																																</v2_topLeftAxis>
																																<style>
																																	<CSS value="width:445px;height:150px;color:#454545"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
																																<noDataHandler>
																																	<contents>
																																		<block>
																																			<contents>
																																				<textItem>
																																					<dataSource>
																																						<staticValue>No Data Available</staticValue>
																																					</dataSource>
																																					<style>
																																						<CSS value="padding:10px 18px;"/>
																																					</style>
																																				</textItem>
																																			</contents>
																																		</block>
																																	</contents>
																																</noDataHandler>
																															</v2_combinationChart>
																														</contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Cost per IOpS Trends</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" name="Combination Chart8" refQuery="Cost per IOpS Trends">
																				<v2_combinationTypeTooltips/>
																				<v2_commonAxis>
																					<v2_ordinalAxis>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/></style>
																						</v2_axisLabels>
																					</v2_ordinalAxis>
																					<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Date"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Date"/></dataSource></chartTextItem></chartContents><style><dataFormat><dateFormat pattern="yy/MM"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																				<v2_topLeftAxis>
																					<v2_combinationChartTypes>
																						<v2_line lineAreaShape="smooth" lineDisplayType="lineAndMarkers"><v2_linePalette markerBorderColor="white" markerBorders="show" markerSize="8px"><v2_linePaletteEntries><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#8599D3"><v2_solidColor color="#9ABCC3" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#8599D3"><v2_color color="#9ABCC3"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#E3AE6C"><v2_solidColor color="#A8E3D7" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#E3AE6C"><v2_color color="#A8E3D7"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry><v2_lineFill defaultColor="#198545"><v2_color color="#88B2D3"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry><v2_lineFill defaultColor="#198545"><v2_color color="#FFB2C1"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry></v2_linePaletteEntries></v2_linePalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Cost per IOpS"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_line></v2_combinationChartTypes>
																					<v2_axis>
																						<v2_axisRange scale="linear">
																							
																						<v2_automaticRange sameRangeAllInstances="true" includeZeroForAutoScale="true"/></v2_axisRange>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/><dataFormat><numberFormat pattern="$###,### K"/></dataFormat></style>
																						</v2_axisLabels>
																						<v2_majorGridlines lineColor="#EEEEF0" lineWeight="0"/>
																					</v2_axis>
																				</v2_topLeftAxis>
																				<style>
																					<defaultStyles>
																						<defaultStyle refStyle="ch"/>
																					</defaultStyles>
																					<CSS value="width:445px;height:150px"/></style>
																				<noDataHandler>
																					<contents>
																						<block>
																							<contents>
																								<textItem>
																									<dataSource>
																										<staticValue>No Data Available</staticValue>
																									</dataSource>
																									<style>
																										<CSS value="padding:10px 18px;"/>
																									</style>
																								</textItem>
																							</contents>
																						</block>
																					</contents>
																				</noDataHandler>
																				<v2_legend>
																					<v2_legendPosition>
																						<v2_legendPreset legendPositionPreset="bottom"/>
																					</v2_legendPosition>
																					<style>
																						<defaultStyles>
																							<defaultStyle refStyle="lg"/>
																						</defaultStyles>
																					<CSS value="font-family:Arial;color:#454545"/></style>
																				</v2_legend>
																				<XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding:5px 10px 5px 10px;height:10px;background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;width:100%;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Storage Cost Detail by Host/Server</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<list horizontalPagination="true" name="List1" refQuery="Chargeback Detail" rowsPerPage="20">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse;width:100%"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Tenant"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Tenant"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Line of Business"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Line of Business"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Business Unit"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Business Unit"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Project"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Project"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Application"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Application"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Host"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Host"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="OS"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="OS"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Host Type"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Host Type"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Processors"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Processors"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Memory"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Memory"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="ConfiguredAs"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="ConfiguredAs"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Configured Cost"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><dataFormat><currencyFormat/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Configured Cost"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Total Provisioned (GB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Total Provisioned (GB)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Total Provisioned Cost"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><dataFormat><currencyFormat/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Total Provisioned Cost"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns></list></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell><tableCell><contents/><style><CSS value="padding-left:15px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="background-color:#F7F7F7;padding-right:10px;padding-left:10px;padding-bottom:10px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Cost Parameters</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Configured  </staticValue></dataSource><style><CSS value="font-weight:bold;color:gray"/></style></textItem></contents><style><CSS value="padding-right:15px;padding-left:5px;border-top:1pt solid silver;border-bottom:1pt solid silver;border-left:1pt solid silver"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-spacing:0;border:1pt solid silver"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Type</staticValue></dataSource><style><CSS value="font-weight:bold;color:gray;font-size:9pt"/></style></textItem></contents><style><CSS value="width:100px;padding-top:3px;padding-bottom:3px;border-bottom:1pt solid silver"/></style></tableCell><tableCell colSpan="2"><contents><textItem><dataSource><staticValue>Monthly Rate (per Instance)</staticValue></dataSource><style><CSS value="color:gray;font-weight:bold;font-size:9pt"/></style></textItem></contents><style><CSS value="padding-top:3px;padding-bottom:3px;text-align:center;border-bottom:1pt solid silver"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="color:#696969;padding-top:3px;padding-bottom:3px"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Windows</staticValue></dataSource><style><CSS value="color:gray;font-weight:bold;font-size:9pt"/></style></textItem></contents><style><CSS value="width:200px;padding-top:3px;padding-bottom:3px;text-align:right;padding-right:15px"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Linux</staticValue></dataSource><style><CSS value="font-weight:bold;color:gray;font-size:9pt"/></style></textItem></contents><style><CSS value="width:200px;padding-top:3px;padding-bottom:3px;text-align:right;padding-right:15px;border-left:1pt solid silver"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>t2.small</staticValue></dataSource></textItem></contents><style><CSS value="color:#696969;font-weight:normal;padding-left:5px;border-top:1pt solid silver;border-bottom:1pt solid silver;border-right:1pt solid silver"/></style></tableCell><tableCell><contents><textBox parameter="t2smallWindows" numbersOnly="true" required="false"><defaultSelections><defaultSimpleSelection>17.16</defaultSimpleSelection></defaultSelections><style><CSS value="direction:rtl;width:65px"/></style></textBox></contents><style><CSS value="text-align:right;padding-top:2px;padding-bottom:2px;border-top:1pt solid silver;border-bottom:1pt solid silver"/></style></tableCell><tableCell><contents><textBox parameter="t2smallLinux" numbersOnly="true" required="false"><defaultSelections><defaultSimpleSelection>10.44</defaultSimpleSelection></defaultSelections><style><CSS value="direction:rtl;width:65px"/></style></textBox></contents><style><CSS value="text-align:right;padding-top:2px;padding-bottom:2px;border-top:1pt solid silver;border-bottom:1pt solid silver;border-left:1pt solid silver"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>m4.large</staticValue></dataSource></textItem></contents><style><CSS value="color:#696969;font-weight:normal;padding-left:5px;border-bottom:1pt solid silver;border-right:1pt solid silver"/></style></tableCell><tableCell><contents><textBox parameter="m4largeWindows" numbersOnly="true" required="false"><defaultSelections><defaultSimpleSelection>108.92</defaultSimpleSelection></defaultSelections><style><CSS value="direction:rtl;width:65px"/></style></textBox></contents><style><CSS value="text-align:right;padding-top:2px;padding-bottom:2px;border-bottom:1pt solid silver"/></style></tableCell><tableCell><contents><textBox parameter="m4largeLinux" numbersOnly="true" required="false"><defaultSelections><defaultSimpleSelection>41.76</defaultSimpleSelection></defaultSelections><style><CSS value="direction:rtl;width:65px"/></style></textBox></contents><style><CSS value="text-align:right;padding-top:2px;padding-bottom:2px;border-bottom:1pt solid silver;border-left:1pt solid silver"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>m4.xlarge</staticValue></dataSource></textItem></contents><style><CSS value="color:#696969;font-weight:normal;padding-left:5px;border-bottom:1pt solid silver;border-right:1pt solid silver"/></style></tableCell><tableCell><contents><textBox parameter="m4xlargeWindows" numbersOnly="true" required="false"><defaultSelections><defaultSimpleSelection>217.91</defaultSimpleSelection></defaultSelections><style><CSS value="direction:rtl;width:65px"/></style></textBox></contents><style><CSS value="text-align:right;padding-top:2px;padding-bottom:2px;border-bottom:1pt solid silver"/></style></tableCell><tableCell><contents><textBox parameter="m4xlargeLinux" numbersOnly="true" required="false"><defaultSelections><defaultSimpleSelection>83.59</defaultSimpleSelection></defaultSelections><style><CSS value="direction:rtl;width:65px"/></style></textBox></contents><style><CSS value="text-align:right;padding-top:2px;padding-bottom:2px;border-bottom:1pt solid silver;border-left:1pt solid silver"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>m4.2xlarge</staticValue></dataSource><style><CSS value="color:#696969"/></style></textItem></contents><style><CSS value="color:#696969;font-weight:normal;padding-left:5px;border-bottom:1pt solid silver;border-right:1pt solid silver"/></style></tableCell><tableCell><contents><textBox parameter="m42xlargeWindows" numbersOnly="true" required="false"><defaultSelections><defaultSimpleSelection>435.81</defaultSimpleSelection></defaultSelections><style><CSS value="direction:rtl;width:65px"/></style></textBox></contents><style><CSS value="text-align:right;padding-top:2px;padding-bottom:2px;border-bottom:1pt solid silver"/></style></tableCell><tableCell><contents><textBox parameter="m42xlargeLinux" numbersOnly="true" required="false"><defaultSelections><defaultSimpleSelection>167.17</defaultSimpleSelection></defaultSelections><style><CSS value="direction:rtl;width:65px"/></style></textBox></contents><style><CSS value="text-align:right;padding-top:2px;padding-bottom:2px;border-bottom:1pt solid silver;border-left:1pt solid silver"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>m4.4xlarge</staticValue></dataSource></textItem></contents><style><CSS value="color:#696969;font-weight:normal;padding-left:5px;border-bottom:1pt solid silver;border-right:1pt solid silver"/></style></tableCell><tableCell><contents><textBox parameter="m44xlargeWindows" numbersOnly="true" required="false"><defaultSelections><defaultSimpleSelection>871.55</defaultSimpleSelection></defaultSelections><style><CSS value="direction:rtl;width:65px"/></style></textBox></contents><style><CSS value="text-align:right;padding-top:2px;padding-bottom:2px;border-bottom:1pt solid silver"/></style></tableCell><tableCell><contents><textBox parameter="m44xlargeLinux" numbersOnly="true" required="false"><defaultSelections><defaultSimpleSelection>334.27</defaultSimpleSelection></defaultSelections><style><CSS value="direction:rtl;width:65px"/></style></textBox></contents><style><CSS value="text-align:right;padding-top:2px;padding-bottom:2px;border-bottom:1pt solid silver;border-left:1pt solid silver"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>m4.10xlarge</staticValue></dataSource><style><CSS value="color:#696969"/></style></textItem></contents><style><CSS value="color:#696969;font-weight:normal;padding-left:5px;border-bottom:1pt solid silver;border-right:1pt solid silver"/></style></tableCell><tableCell><contents><textBox parameter="m410xlargeWindows" numbersOnly="true" required="false"><defaultSelections><defaultSimpleSelection>2178.90</defaultSimpleSelection></defaultSelections><style><CSS value="direction:rtl;width:65px"/></style></textBox></contents><style><CSS value="text-align:right;padding-top:2px;padding-bottom:2px;border-bottom:1pt solid silver"/></style></tableCell><tableCell><contents><textBox parameter="m410xlargeLinux" numbersOnly="true" required="false"><defaultSelections><defaultSimpleSelection>835.70</defaultSimpleSelection></defaultSelections><style><CSS value="direction:rtl;width:65px"/></style></textBox></contents><style><CSS value="text-align:right;padding-top:2px;padding-bottom:2px;border-bottom:1pt solid silver;border-left:1pt solid silver"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>m4.16xlarge</staticValue></dataSource><style><CSS value="color:#696969"/></style></textItem></contents><style><CSS value="color:#696969;font-weight:normal;padding-left:5px;border-right:1pt solid silver"/></style></tableCell><tableCell><contents><textBox parameter="m416xlargeWindows" numbersOnly="true" required="false"><defaultSelections><defaultSimpleSelection>3486.26</defaultSimpleSelection></defaultSelections><style><CSS value="direction:rtl;width:65px"/></style></textBox></contents><style><CSS value="text-align:right;padding-top:2px;padding-bottom:2px"/></style></tableCell><tableCell><contents><textBox parameter="m416xlargeLinux" numbersOnly="true" required="false"><defaultSelections><defaultSimpleSelection>1337.14</defaultSimpleSelection></defaultSelections><style><CSS value="direction:rtl;width:65px"/></style></textBox></contents><style><CSS value="text-align:right;padding-top:2px;padding-bottom:2px;border-left:1pt solid silver"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><promptButton type="next">
			<contents><textItem><dataSource><staticValue>Refresh Configured Costs</staticValue></dataSource></textItem></contents>
			<style>
				<defaultStyles>
					<defaultStyle refStyle="bp"/>
				</defaultStyles>
			<CSS value="background-color:silver"/></style>
		</promptButton></contents><style><CSS value="padding-top:5px;padding-bottom:5px;padding-left:10px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding:5px;border-top:1pt solid silver;border-bottom:1pt solid silver;border-right:1pt solid silver"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue> </staticValue></dataSource></textItem><textItem><dataSource><staticValue>Tier/Service Level</staticValue></dataSource><style><CSS value="font-weight:bold;color:gray"/></style></textItem></contents><style><CSS value="text-align:center;border-top:1pt solid #ADB2B5;border-bottom:1pt solid #ADB2B5;border-left:1pt solid #ADB2B5"/></style></tableCell><tableCell><contents><list horizontalPagination="true" name="List2" refQuery="Tier or Service Level Data">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Tier"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Tier"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Tier Cost"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Tier Cost"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns></list></contents><style><CSS value="padding-top:15px;padding-bottom:15px;text-align:center;border:1pt solid #ADB2B5"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell colSpan="2"><contents/><style><CSS value="padding:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top;padding-left:15px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents>
								</pageBody>
								
								<pageFooter>
									<contents>
										
									<table>
                                            <tableRows>
                                                <tableRow>
                                                    <tableCells>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <image>
            <dataSource>
                <staticValue>../sanscreen/images/netapp_logo.png</staticValue>
            </dataSource>
        <style><CSS value="width:90px;height:36px"/></style></image></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:left;width:30%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                <textItem><dataSource><staticValue>Page </staticValue></dataSource></textItem><pageNumber/>
                                                            </contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:center;color:#9EA2A2;font-family:Helvetica;font-size:12px;width:40%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <textItem><dataSource><staticValue>OnCommand Insight 7.3.  2014-18 NetApp.</staticValue></dataSource><style><CSS value="font-weight:normal"/></style></textItem></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:right;width:30%;color:#9EA2A2;font-family:Arial;font-size:12px"/>
                                                            </style>
                                                        </tableCell>
                                                    </tableCells>
                                                </tableRow>
                                            </tableRows>
                                            <style>
                                                <defaultStyles>
                                                    <defaultStyle refStyle="tb"/>
                                                </defaultStyles>
                                                <CSS value="border-collapse:collapse;width:100%;height:32px"/>
                                            </style>
                                        </table></contents>
									<style>
										<defaultStyles>
											<defaultStyle refStyle="pf"/>
										</defaultStyles>
										<CSS value="padding-top:10px"/>
									</style>
								</pageFooter>
							</page>
						</reportPages>
					</layout>
				</layouts>
			<XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" output="no" value="true"/><XMLAttribute name="listSeparator" output="no" value=","/><XMLAttribute name="RS_modelModificationTime" output="no" value="2017-11-15T20:33:46.811Z"/></XMLAttributes><reportName>5.1 Chargeback</reportName><classStyles><classStyle name="freezeColumns" label="freezeColumns"/><classStyle name="freezeRows" label="freezeRows"/><classStyle name="freezeCorner" label="freezeCorner"/></classStyles><namedConditionalStyles><advancedConditionalStyle name="Conditional Style 1"><styleCases><styleCase><style><CSS value="color:#CF2128"/></style><reportCondition>[Capacity Changes].[Raw Change] &lt; 0</reportCondition></styleCase><styleCase><style><CSS value="color:#77BF72"/></style><reportCondition>[Capacity Changes].[Raw Change] &gt; 0</reportCondition></styleCase></styleCases><styleDefault><style><CSS value="color:#808080"/></style></styleDefault></advancedConditionalStyle><advancedConditionalStyle name="Conditional Style 2"><styleCases><styleCase><style><CSS value="color:#CF2128"/></style><reportCondition>[Capacity Changes].[Usable Change] &lt; 0</reportCondition></styleCase><styleCase><style><CSS value="color:#77BF72"/></style><reportCondition>[Capacity Changes].[Usable Change] &gt;0</reportCondition></styleCase></styleCases><styleDefault><style><CSS value="color:#808080"/></style></styleDefault></advancedConditionalStyle><advancedConditionalStyle name="Conditional Style 3"><styleCases><styleCase><style><CSS value="color:#CF2128"/></style><reportCondition>[Capacity Changes].[Internal Volume Allocated Change] &lt; 0</reportCondition></styleCase><styleCase><style><CSS value="color:#77BF72"/></style><reportCondition>[Capacity Changes].[Internal Volume Allocated Change] &gt; 0</reportCondition></styleCase></styleCases><styleDefault><style><CSS value="color:#808080"/></style></styleDefault></advancedConditionalStyle><advancedConditionalStyle name="Conditional Style 4"><styleCases><styleCase><style><CSS value="color:#CF2128"/></style><reportCondition>[Capacity Changes].[Volume Allocated Change] &lt; 0</reportCondition></styleCase><styleCase><style><CSS value="color:#77BF72"/></style><reportCondition>[Capacity Changes].[Volume Allocated Change] &gt; 0</reportCondition></styleCase></styleCases><styleDefault><style><CSS value="color:#808080"/></style></styleDefault></advancedConditionalStyle><advancedConditionalStyle name="Conditional Style 5"><styleCases><styleCase><style><CSS value="color:#CF2128"/></style><reportCondition>[Capacity Changes].[Used Change] &lt; 0</reportCondition></styleCase><styleCase><style><CSS value="color:#77BF72"/></style><reportCondition>[Capacity Changes].[Used Change] &gt; 0</reportCondition></styleCase></styleCases><styleDefault><style><CSS value="color:#808080"/></style></styleDefault></advancedConditionalStyle><advancedConditionalStyle name="Conditional Style 6"><styleCases><styleCase><style><CSS value="color:#CF2128"/></style><reportCondition>[Capacity Changes].[Free Change] &lt; 0</reportCondition></styleCase><styleCase><style><CSS value="color:#77BF72"/></style><reportCondition>[Capacity Changes].[Free Change] &gt; 0</reportCondition></styleCase></styleCases><styleDefault><style><CSS value="color:#808080"/></style></styleDefault></advancedConditionalStyle></namedConditionalStyles><queries><query name="Cost per IOpS">
			<source>
				
			<sqlQuery name="SQL8" dataSource="dwh_performance" type="passThrough">
			<sqlText>SELECT     
    diskPerf.datacenter as 'DataCenter',
    diskPerf.array as 'Array',
	diskPerf.poolname as 'PoolName',
    diskPerf.disk as 'DiskName',   
    diskPerf.Tier as 'Tier',
    diskPerf.Cost as 'Cost',
    diskPerf.DiskCapacityGB as 'Capacity GB',
    ROUND(diskPerf.totalIops,0) AS 'DiskIOPS',
  
	 diskPerf.poolIOpSCapability AS 'poolIOpSCapability',
	 
	ROUND( (diskPerf.Cost * diskPerf.DiskCapacityGB) / diskPerf.poolIOpSCapability ,2) as 'Cost per IOpS'
	 
	 
	 

FROM    (
SELECT
    dwh_performance.storage_dimension.name as array,
    dwh_performance.storage_dimension.datacenter as datacenter,
	dwh_performance.storage_pool_dimension.name as poolname,
       dwh_inventory.disk.name as disk,
        IF(dwh_inventory.annotation_value.annotationtype='Tier', dwh_inventory.annotation_value.valueIdentifier, null) as 'Tier',
  IF(dwh_inventory.annotation_value.annotationtype='Tier', dwh_inventory.annotation_value.enumCost, null) as 'Cost',
        SUM(dwh_performance.disk_daily_performance_fact.totalIops) totalIops,
		SUM(dwh_performance.disk_daily_performance_fact.totalIopsmax) totalIopsmax,
        SUM(dwh_performance.disk_daily_performance_fact.readIops) readIops,
        SUM(dwh_performance.disk_daily_performance_fact.writeIops) writeIops,
        SUM(dwh_performance.disk_daily_performance_fact.totalThroughput) totalThroughput,
        SUM(dwh_performance.disk_daily_performance_fact.readThroughput) readThroughput,
        SUM(dwh_performance.disk_daily_performance_fact.writeThroughput) writeThroughput,
       
		
			COUNT(DISTINCT dwh_inventory.disk.id) AS 'diskCount',
				
			CASE
				WHEN MIN(CASE
					WHEN dwh_inventory.disk.type = 'SSD' THEN 4
					WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 15000 THEN 3
					WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 15000 THEN 3
					WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 10000 THEN 2
					WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 10000 THEN 2
					ELSE 1
					END) = 4 THEN 3000
				WHEN MIN(CASE
					WHEN dwh_inventory.disk.type = 'SSD' THEN 4
					WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 15000 THEN 3
					WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 15000 THEN 3
					WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 10000 THEN 2
					WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 10000 THEN 2
					ELSE 1
					END) = 3 THEN 200
				WHEN MIN(CASE
					WHEN dwh_inventory.disk.type = 'SSD' THEN 4
					WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 15000 THEN 3
					WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 15000 THEN 3
					WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 10000 THEN 2
					WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 10000 THEN 2
					ELSE 1
					END) = 2 THEN 170
				ELSE 75
			END AS 'diskIOpSCapability',
		
				COUNT(DISTINCT dwh_inventory.disk.id) *
				(CASE
					WHEN MIN(CASE
						WHEN dwh_inventory.disk.type = 'SSD' THEN 4
						WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 15000 THEN 3
						WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 15000 THEN 3
						WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 10000 THEN 2
						WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 10000 THEN 2
						ELSE 1
						END) = 4 THEN 3000
					WHEN MIN(CASE
						WHEN dwh_inventory.disk.type = 'SSD' THEN 4
						WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 15000 THEN 3
						WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 15000 THEN 3
						WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 10000 THEN 2
						WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 10000 THEN 2
						ELSE 1
						END) = 3 THEN 200
					WHEN MIN(CASE
						WHEN dwh_inventory.disk.type = 'SSD' THEN 4
						WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 15000 THEN 3
						WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 15000 THEN 3
						WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 10000 THEN 2
						WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 10000 THEN 2
						ELSE 1
						END) = 2 THEN 170
					ELSE 75
				END ) AS 'poolIopsCapability',
               
			   CASE
					WHEN MIN(CASE
						WHEN dwh_inventory.disk.type = 'SSD' THEN 4
						WHEN dwh_inventory.disk.type = 'SAS' THEN 3
						WHEN dwh_inventory.disk.type = 'FC'  THEN 2
                        WHEN dwh_inventory.disk.type LIKE '%SATA%' THEN 1
						ELSE 0
						END) = 4 THEN 'SSD'
					WHEN MIN(CASE
						WHEN dwh_inventory.disk.type = 'SSD' THEN 4
						WHEN dwh_inventory.disk.type = 'SAS' THEN 3
						WHEN dwh_inventory.disk.type = 'FC'  THEN 2
                        WHEN dwh_inventory.disk.type LIKE '%SATA%' THEN 1
						ELSE 0
						END) = 3 THEN 'SAS'
					WHEN MIN(CASE
						WHEN dwh_inventory.disk.type = 'SSD' THEN 4
						WHEN dwh_inventory.disk.type = 'SAS' THEN 3
						WHEN dwh_inventory.disk.type = 'FC' THEN 2
						WHEN dwh_inventory.disk.type LIKE '%SATA%' THEN 1
						ELSE 0
						END) = 2 THEN 'FC'
                     WHEN MIN(CASE
						WHEN dwh_inventory.disk.type = 'SSD' THEN 4
						WHEN dwh_inventory.disk.type = 'SAS' THEN 3
						WHEN dwh_inventory.disk.type = 'FC'  THEN 2
						WHEN dwh_inventory.disk.type LIKE '%SATA%' THEN 1
						ELSE 0
						END) = 1 THEN 'SATA'   
					ELSE 'Not Defined'
					END AS 'diskType',
                    MIN(dwh_inventory.disk.speed) AS 'diskSpeed',
					dwh_inventory.disk.capacityGB AS 'diskCapacityGB'
		
		
    FROM    dwh_performance.disk_daily_performance_fact
    JOIN    dwh_performance.storage_dimension
    ON  dwh_performance.disk_daily_performance_fact.storageTk = dwh_performance.storage_dimension.tk
    JOIN    dwh_performance.storage_pool_dimension
    ON  dwh_performance.disk_daily_performance_fact.storagePoolTk = dwh_performance.storage_pool_dimension.tk
    
    JOIN    dwh_performance.date_dimension
    ON  dwh_performance.disk_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk
    AND     dwh_performance.date_dimension.fullDate &gt;= (     SELECT  MAX(dwh_performance.date_dimension.fullDate)
                                FROM    dwh_performance.disk_daily_performance_fact
                                JOIN    dwh_performance.date_dimension
                                ON  dwh_performance.disk_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk ) - INTERVAL 0 DAY
   
    JOIN    dwh_performance.disk_dimension
    ON  dwh_performance.disk_daily_performance_fact.diskTk = dwh_performance.disk_dimension.tk
    AND     dwh_performance.disk_dimension.role = 'DATA'
	JOIN  dwh_inventory.disk
	ON   dwh_inventory.disk.id=dwh_performance.disk_dimension.id
	JOIN dwh_inventory.storage_pool_to_disk
	ON   dwh_inventory.storage_pool_to_disk.diskid=dwh_inventory.disk.id
	JOIN dwh_inventory.storage_pool
	ON   dwh_inventory.storage_pool.id=dwh_inventory.storage_pool_to_disk.storagepoolid
	LEFT JOIN dwh_inventory.object_to_annotation
	ON   dwh_inventory.object_to_annotation.objectid=dwh_inventory.storage_pool.id
	LEFT JOIN dwh_inventory.annotation_value
	ON   dwh_inventory.annotation_value.id=dwh_inventory.object_to_annotation.annotationValueid
	
	
    GROUP BY
      dwh_inventory.disk.id 
      
       
    ) diskPerf</sqlText>
		<mdProjectedItems><mdProjectedItem name="DataCenter"/><mdProjectedItem name="Array"/><mdProjectedItem name="PoolName"/><mdProjectedItem name="DiskName"/><mdProjectedItem name="Tier"/><mdProjectedItem name="Cost"/><mdProjectedItem name="Capacity GB"/><mdProjectedItem name="DiskIOPS"/><mdProjectedItem name="poolIOpSCapability"/><mdProjectedItem name="Cost per IOpS"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="DataCenter"><expression>[SQL8].[DataCenter]</expression></dataItem><dataItem name="Array"><expression>[SQL8].[Array]</expression></dataItem><dataItem name="PoolName"><expression>[SQL8].[PoolName]</expression></dataItem><dataItem name="DiskName"><expression>[SQL8].[DiskName]</expression></dataItem><dataItem name="Tier"><expression>[SQL8].[Tier]</expression></dataItem><dataItem name="Cost"><expression>[SQL8].[Cost]</expression></dataItem><dataItem name="Capacity GB"><expression>[SQL8].[Capacity GB]</expression></dataItem><dataItem name="DiskIOPS"><expression>[SQL8].[DiskIOPS]</expression></dataItem><dataItem name="poolIOpSCapability"><expression>[SQL8].[poolIOpSCapability]</expression></dataItem><dataItem name="Cost per IOpS" aggregate="average"><expression>[SQL8].[Cost per IOpS]</expression></dataItem></selection>
		</query><query name="Chargeback Detail">
			<source>
				
			<sqlQuery name="SQL7" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT 	
        x.Tenant as 'Tenant',
        x.LineofBusiness as 'Line of Business',
        x.BusinessUnit as 'Business Unit',
        x.Project as 'Project',
        x.Application as 'Application',
        x.Host as 'Host',
        IF(x.OS LIKE CONCAT('%','Windows','%'), 'Windows', 
        IF(x.OS LIKE CONCAT('%','Linux','%'), 'Linux', null )) as 'OS', 
                  
        x.Type as 'Host Type',
        x.Processors as 'Processors',
 

CASE 
	WHEN x.Processors=1 THEN 't2.small'
	WHEN x.Processors&lt;=2 THEN 'm4.large'
	WHEN x.Processors&lt;=4 THEN 'm4.xlarge'
	WHEN x.Processors&lt;=8 THEN 'm4.2xlarge'
	WHEN x.Processors&lt;=16 THEN 'm4.4xlarge'
	WHEN x.Processors&lt;=40 THEN 'm4.10xlarge'            
	ELSE IF(x.Processors is null, null, 'm4.16xlarge')
        END AS 'ConfiguredAs',


       x.Memory as 'Memory',
        x.provTB AS 'Total Provisioned (TB)',
        x.provGB as 'Total Provisioned (GB)',
		SUM(x.cost) AS 'Total Provisioned Cost',
		
		IF(x.Type='Physical', SUM(x.cost), 0) as 'Physical Compute Cost',
	IF(x.Type='Virtual', SUM(x.cost), 0) as 'Virtual Compute Cost'
	
FROM 	(
	SELECT 	
	
	        total.Tenant,
	        total.LineofBusiness,
	        total.BusinessUnit,
	        total.Project,
	        total.Application,
	        total.Host as 'Host',
	        total.OS as 'OS',
	        total.Type as 'Type',
	        total.Processors as 'Processors',
	        total.memory as 'Memory',
	        SUM(total.provTB) AS provTB,
	        SUM(total.provGB) as provGB,
		SUM(total.cost) AS cost
	FROM 	(
		SELECT 	
		
		dwh_capacity.business_entity_dimension.tenant AS 'Tenant',
                dwh_capacity.business_entity_dimension.lob AS 'LineofBusiness',
                dwh_capacity.business_entity_dimension.businessUnit AS 'BusinessUnit',
                dwh_capacity.business_entity_dimension.project AS 'Project',
                dwh_capacity.application_dimension.name AS 'Application',

		dwh_capacity.host_dimension.name as 'Host',
		null as 'OS',
		null as 'Processors',
		null as 'Memory',
		
		'Physical' as 'Type',

		CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	dwh_capacity.tier_dimension.name
				ELSE 	dwh_capacity.service_level_dimension.name
			END 	AS 	tier,
			CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	dwh_inventory.tier.cost
				ELSE 	dwh_inventory.service_level.cost
			END 	AS 	tierPerGB,
			dwh_capacity.date_dimension.fullDate AS fullDate,
			ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024/1024,2) AS provTB,
			ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) AS provGB,
			
			CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	ROUND(ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) * dwh_inventory.tier.cost, 2)
				ELSE 	ROUND(ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) * dwh_inventory.service_level.cost, 2)
			END 	AS 	cost
		FROM 	dwh_capacity.chargeback_fact
		JOIN 	dwh_capacity.service_level_dimension
		ON 	dwh_capacity.chargeback_fact.serviceLevelTk = dwh_capacity.service_level_dimension.tk
		AND 	dwh_capacity.chargeback_fact.mappedByVM = 0
		JOIN 	dwh_capacity.tier_dimension
		ON 	dwh_capacity.chargeback_fact.tierTk = dwh_capacity.tier_dimension.tk
		JOIN 	dwh_capacity.date_dimension
		ON 	dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk
		AND 	dwh_capacity.date_dimension.latest = 1
		JOIN 	dwh_inventory.tier
		ON 	dwh_capacity.tier_dimension.id = dwh_inventory.tier.id
		JOIN 	dwh_inventory.service_level
		ON 	dwh_capacity.service_level_dimension.id = dwh_inventory.service_level.id
		LEFT JOIN    dwh_capacity.business_entity_dimension
		ON      dwh_capacity.business_entity_dimension.tk=dwh_capacity.chargeback_fact.businessentitytk
		LEFT JOIN    dwh_capacity.application_dimension
		ON           dwh_capacity.application_dimension.tk=dwh_capacity.chargeback_fact.applicationtk
		LEFT JOIN    dwh_capacity.host_dimension
		ON           dwh_capacity.host_dimension.tk=dwh_capacity.chargeback_fact.hosttk
		
		GROUP BY
			Tier, Host,
			dwh_capacity.date_dimension.fullDate
		UNION
		SELECT 	

                dwh_capacity.business_entity_dimension.tenant AS 'Tenant',
                dwh_capacity.business_entity_dimension.lob AS 'LineofBusiness',
                dwh_capacity.business_entity_dimension.businessUnit AS 'BusinessUnit',
                dwh_capacity.business_entity_dimension.project AS 'Project',
                dwh_capacity.application_dimension.name AS 'Application',

		dwh_capacity.vm_dimension.name as 'Host',
		dwh_capacity.vm_dimension.os as 'OS',
		(SELECT dwh_inventory.hv_virtual_machine.processors FROM dwh_inventory.hv_virtual_machine 
		WHERE dwh_inventory.hv_virtual_machine.id=dwh_capacity.vm_dimension.id) as 'Processors',
		
		(SELECT dwh_inventory.hv_virtual_machine.memory FROM dwh_inventory.hv_virtual_machine 
		WHERE dwh_inventory.hv_virtual_machine.id=dwh_capacity.vm_dimension.id) as 'Memory',
		
		'Virtual' as 'Type',
		
		CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	dwh_capacity.tier_dimension.name
				ELSE 	dwh_capacity.service_level_dimension.name
			END 	AS 	tier,
			CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	dwh_inventory.tier.cost
				ELSE 	dwh_inventory.service_level.cost
			END 	AS 	tierPerGB,
			dwh_capacity.date_dimension.fullDate AS fullDate,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024/1024,2) AS provTB,
                        ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024,2) AS provGB,
			CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	ROUND(ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024,2) * dwh_inventory.tier.cost, 2)
				ELSE 	ROUND(ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024,2) * dwh_inventory.service_level.cost, 2)
			END 	AS 	cost
		FROM 	dwh_capacity.vm_capacity_fact
		JOIN 	dwh_capacity.service_level_dimension
		ON 	dwh_capacity.vm_capacity_fact.serviceLevelTk = dwh_capacity.service_level_dimension.tk
		JOIN 	dwh_capacity.tier_dimension
		ON 	dwh_capacity.vm_capacity_fact.tierTk = dwh_capacity.tier_dimension.tk
		JOIN 	dwh_capacity.date_dimension
		ON 	dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
		AND 	dwh_capacity.date_dimension.latest = 1
		LEFT JOIN 	dwh_inventory.tier
		ON 	dwh_capacity.tier_dimension.id = dwh_inventory.tier.id
		LEFT JOIN 	dwh_inventory.service_level
		ON 	dwh_capacity.service_level_dimension.id = dwh_inventory.service_level.id
		LEFT JOIN    dwh_capacity.business_entity_dimension
		ON      dwh_capacity.business_entity_dimension.tk=dwh_capacity.vm_capacity_fact.businessentitytk
		LEFT JOIN    dwh_capacity.application_dimension
		ON           dwh_capacity.application_dimension.tk=dwh_capacity.vm_capacity_fact.applicationtk
		LEFT JOIN    dwh_capacity.vm_dimension
		ON           dwh_capacity.vm_dimension.tk=dwh_capacity.vm_capacity_fact.vmtk
		
		GROUP BY
			Tier, Host,
			dwh_capacity.date_dimension.fullDate
		) total
	GROUP BY Host
	
	) X
	
	GROUP BY Host
	</sqlText>
		<mdProjectedItems><mdProjectedItem name="Tenant"/><mdProjectedItem name="Line of Business"/><mdProjectedItem name="Business Unit"/><mdProjectedItem name="Project"/><mdProjectedItem name="Application"/><mdProjectedItem name="Host"/><mdProjectedItem name="OS"/><mdProjectedItem name="Host Type"/><mdProjectedItem name="Processors"/><mdProjectedItem name="ConfiguredAs"/><mdProjectedItem name="Memory"/><mdProjectedItem name="Total Provisioned (TB)"/><mdProjectedItem name="Total Provisioned (GB)"/><mdProjectedItem name="Total Provisioned Cost"/><mdProjectedItem name="Physical Compute Cost"/><mdProjectedItem name="Virtual Compute Cost"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Tenant"><expression>[SQL7].[Tenant]</expression></dataItem><dataItem name="Line of Business"><expression>[SQL7].[Line of Business]</expression></dataItem><dataItem name="Business Unit"><expression>[SQL7].[Business Unit]</expression></dataItem><dataItem name="Project"><expression>[SQL7].[Project]</expression></dataItem><dataItem name="Application"><expression>[SQL7].[Application]</expression></dataItem><dataItem name="Host"><expression>[SQL7].[Host]</expression></dataItem><dataItem name="OS"><expression>[SQL7].[OS]</expression></dataItem><dataItem name="Host Type"><expression>[SQL7].[Host Type]</expression></dataItem><dataItem name="Processors"><expression>[SQL7].[Processors]</expression></dataItem><dataItem name="Memory"><expression>[SQL7].[Memory]</expression></dataItem><dataItem name="ConfiguredAs"><expression>[SQL7].[ConfiguredAs]</expression></dataItem><dataItem name="Configured Cost" aggregate="total"><expression> 
   
      case
   when ( [OS] = 'Windows' ) then
      Case
	when ( [ConfiguredAs] = 't2.small' ) then (#prompt('t2smallWindows','float','17.16')# )
	when ( [ConfiguredAs] = 'm4.large' ) then (#prompt('m4largeWindows','float','108.92')# ) 
	when ( [ConfiguredAs] = 'm4.xlarge' )  then (#prompt('m4xlargeWindows','float','217.91')# ) 
        when ( [ConfiguredAs] = 'm4.2xlarge' ) then (#prompt('m42xlargeWindows','float','435.81')# ) 
	when ([ConfiguredAs] = 'm4.4xlarge' ) then (#prompt('m44xlargeWindows','float','871.55')# ) 
        when ( [ConfiguredAs] = 'm4.10xlarge' ) then ( #prompt('m410xlargeWindows','float','2178.90')#) 
        when ( [ConfiguredAs] = 'm4.16xlarge' ) then ( #prompt('m416xlargeWindows','float','3486.26')# ) 
	else ( 0 )
      end
    when ( [OS] = 'Linux' ) then
      Case
	when ([ConfiguredAs] = 't2.small' ) then ( #prompt('t2smallLinux','float','10.44')# )
	when ( [ConfiguredAs] = 'm4.large' ) then ( #prompt('m4largeLinux','float','41.76')# )
	when ([ConfiguredAs] = 'm4.xlarge' ) then ( #prompt('m4xlargeLinux','float','83.59')# )
        when ( [ConfiguredAs] = 'm4.2xlarge' ) then ( #prompt('m42xlargeLinux','float','167.17')# ) 
	when ( [ConfiguredAs] = 'm4.4xlarge' ) then ( #prompt('m44xlargeLinux','float','334.27')# ) 
        when ( [ConfiguredAs] = 'm4.10xlarge' ) then ( #prompt('m410xlargeLinux','float','835.70')# ) 
        when ( [ConfiguredAs] = 'm4.16xlarge' ) then ( #prompt('m416xlargeLinux','float','1337.14')# ) 
	else ( 0 )
      end
end
</expression></dataItem><dataItem name="Total Provisioned (TB)"><expression>[SQL7].[Total Provisioned (TB)]</expression></dataItem><dataItem name="Total Provisioned (GB)"><expression>[SQL7].[Total Provisioned (GB)]</expression></dataItem><dataItem name="Total Provisioned Cost" aggregate="total"><expression>[SQL7].[Total Provisioned Cost]</expression></dataItem><dataItem name="Physical Compute Cost" aggregate="total"><expression>IF([Host Type]='Physical') THEN ([Total Provisioned Cost]/1000/1000) ELSE (0)</expression></dataItem><dataItem name="Virtual Compute Cost" aggregate="total"><expression>IF([Host Type]='Virtual') THEN ([Total Provisioned Cost]/1000/1000) ELSE (0)</expression></dataItem><dataItem name="Linux Configured Cost" aggregate="total"><expression>IF([OS]='Linux') THEN ([Configured Cost]) ELSE (0)</expression></dataItem><dataItem name="Windows Configured Cost" aggregate="total"><expression>IF([OS]='Windows') THEN ([Configured Cost]) ELSE (0)</expression></dataItem></selection>
		</query><query name="Chargeback Changes">
			<source>
				
			<sqlQuery dataSource="dwh_capacity" name="SQL1" type="passThrough">
			<sqlText>SELECT 	x.provTB AS 'Total Provisioned (TB)',
	y.provTB AS 'Total Provisioned (TB) Last Month',
	CASE 	WHEN 	x.provTB &gt;= y.provTB
		THEN 	CONCAT('+', x.provTB - y.provTB)
		ELSE 	x.provTB - y.provTB
	END 	AS 	'Change in Total Provisioned (TB)',
	CASE 	WHEN 	x.provTB &gt;= y.provTB
		THEN 	CONCAT('(+', ROUND((x.provTB - y.provTB)/y.provTB * 100, 2), '%)')
		ELSE 	CONCAT('(', ROUND((x.provTB - y.provTB)/y.provTB * 100, 2), '%)')
	END 	AS 	'Percent Change in Total Provisioned (TB)',
	SUM(x.cost) AS 'Total Provisioned Cost',
	SUM(y.cost) AS 'Total Provisioned Cost Last Month',
	CASE 	WHEN 	x.cost &gt;= y.cost
		THEN 	CONCAT('+', (x.cost - y.cost))
		ELSE 	x.cost - y.cost
	END 	AS 	'Change in Total Provisioned Cost',
	CASE 	WHEN 	x.cost &gt;= y.cost
		THEN 	CONCAT('(+', ROUND((x.cost - y.cost)/y.cost * 100, 2), '%)')
		ELSE 	CONCAT('(', ROUND((x.cost - y.cost)/y.cost * 100, 2), '%)')
	END 	AS 	'Percent Change in Total Provisioned Cost'
FROM 	(
	SELECT 	SUM(total.provTB) AS provTB,
		SUM(total.cost) AS cost
	FROM 	(
		SELECT 	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	dwh_capacity.tier_dimension.name
				ELSE 	dwh_capacity.service_level_dimension.name
			END 	AS 	tier,
			CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	dwh_inventory.tier.cost
				ELSE 	dwh_inventory.service_level.cost
			END 	AS 	tierPerGB,
			dwh_capacity.date_dimension.fullDate AS fullDate,
			ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024/1024,2) AS provTB,
			CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	ROUND(ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) * dwh_inventory.tier.cost, 2)
				ELSE 	ROUND(ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) * dwh_inventory.service_level.cost, 2)
			END 	AS 	cost
		FROM 	dwh_capacity.chargeback_fact
		JOIN 	dwh_capacity.service_level_dimension
		ON 	dwh_capacity.chargeback_fact.serviceLevelTk = dwh_capacity.service_level_dimension.tk
		AND 	dwh_capacity.chargeback_fact.mappedByVM = 0
		JOIN 	dwh_capacity.tier_dimension
		ON 	dwh_capacity.chargeback_fact.tierTk = dwh_capacity.tier_dimension.tk
		JOIN 	dwh_capacity.date_dimension
		ON 	dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk
		AND 	dwh_capacity.date_dimension.latest = 1
		JOIN 	dwh_inventory.tier
		ON 	dwh_capacity.tier_dimension.id = dwh_inventory.tier.id
		JOIN 	dwh_inventory.service_level
		ON 	dwh_capacity.service_level_dimension.id = dwh_inventory.service_level.id
		GROUP BY
			Tier,
			dwh_capacity.date_dimension.fullDate
		UNION
		SELECT 	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	dwh_capacity.tier_dimension.name
				ELSE 	dwh_capacity.service_level_dimension.name
			END 	AS 	tier,
			CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	dwh_inventory.tier.cost
				ELSE 	dwh_inventory.service_level.cost
			END 	AS 	tierPerGB,
			dwh_capacity.date_dimension.fullDate AS fullDate,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024/1024,2) AS provTB,
			CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	ROUND(ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024,2) * dwh_inventory.tier.cost, 2)
				ELSE 	ROUND(ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024,2) * dwh_inventory.service_level.cost, 2)
			END 	AS 	cost
		FROM 	dwh_capacity.vm_capacity_fact
		JOIN 	dwh_capacity.service_level_dimension
		ON 	dwh_capacity.vm_capacity_fact.serviceLevelTk = dwh_capacity.service_level_dimension.tk
		JOIN 	dwh_capacity.tier_dimension
		ON 	dwh_capacity.vm_capacity_fact.tierTk = dwh_capacity.tier_dimension.tk
		JOIN 	dwh_capacity.date_dimension
		ON 	dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
		AND 	dwh_capacity.date_dimension.latest = 1
		LEFT JOIN 	dwh_inventory.tier
		ON 	dwh_capacity.tier_dimension.id = dwh_inventory.tier.id
		LEFT JOIN 	dwh_inventory.service_level
		ON 	dwh_capacity.service_level_dimension.id = dwh_inventory.service_level.id
		GROUP BY
			Tier,
			dwh_capacity.date_dimension.fullDate
		) total
	) X
JOIN 	(
	SELECT 	SUM(total.provTB) AS provTB,
		SUM(total.cost) AS cost
	FROM 	(
		SELECT 	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	dwh_capacity.tier_dimension.name
				ELSE 	dwh_capacity.service_level_dimension.name
			END 	AS 	tier,
			CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	dwh_inventory.tier.cost
				ELSE 	dwh_inventory.service_level.cost
			END 	AS 	tierPerGB,
			dwh_capacity.date_dimension.fullDate AS fullDate,
			ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024/1024,2) AS provTB,
			CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	ROUND(ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) * dwh_inventory.tier.cost, 2)
				ELSE 	ROUND(ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) * dwh_inventory.service_level.cost, 2)
			END 	AS 	cost
		FROM 	dwh_capacity.chargeback_fact
		JOIN 	dwh_capacity.service_level_dimension
		ON 	dwh_capacity.chargeback_fact.serviceLevelTk = dwh_capacity.service_level_dimension.tk
		AND 	dwh_capacity.chargeback_fact.mappedByVM = 0
		JOIN 	dwh_capacity.tier_dimension
		ON 	dwh_capacity.chargeback_fact.tierTk = dwh_capacity.tier_dimension.tk
		JOIN 	dwh_capacity.date_dimension
		ON 	dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk
		AND 	dwh_capacity.date_dimension.fullDate = (SELECT dwh_capacity.date_dimension.fullDate FROM dwh_capacity.date_dimension WHERE latest = 1) - INTERVAL 1 MONTH
		LEFT JOIN 	dwh_inventory.tier
		ON 	dwh_capacity.tier_dimension.id = dwh_inventory.tier.id
		LEFT JOIN 	dwh_inventory.service_level
		ON 	dwh_capacity.service_level_dimension.id = dwh_inventory.service_level.id
		GROUP BY
			Tier,
			dwh_capacity.date_dimension.fullDate
		UNION
		SELECT 	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	dwh_capacity.tier_dimension.name
				ELSE 	dwh_capacity.service_level_dimension.name
			END 	AS 	tier,
			CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	dwh_inventory.tier.cost
				ELSE 	dwh_inventory.service_level.cost
			END 	AS 	tierPerGB,
			dwh_capacity.date_dimension.fullDate AS fullDate,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024/1024,2) AS provTB,
			CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	ROUND(ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024,2) * dwh_inventory.tier.cost, 2)
				ELSE 	ROUND(ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024,2) * dwh_inventory.service_level.cost, 2)
			END 	AS 	cost
		FROM 	dwh_capacity.vm_capacity_fact
		JOIN 	dwh_capacity.service_level_dimension
		ON 	dwh_capacity.vm_capacity_fact.serviceLevelTk = dwh_capacity.service_level_dimension.tk
		JOIN 	dwh_capacity.tier_dimension
		ON 	dwh_capacity.vm_capacity_fact.tierTk = dwh_capacity.tier_dimension.tk
		JOIN 	dwh_capacity.date_dimension
		ON 	dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
		AND 	dwh_capacity.date_dimension.fullDate = (SELECT dwh_capacity.date_dimension.fullDate FROM dwh_capacity.date_dimension WHERE latest = 1) - INTERVAL 1 MONTH
		LEFT JOIN 	dwh_inventory.tier
		ON 	dwh_capacity.tier_dimension.id = dwh_inventory.tier.id
		LEFT JOIN 	dwh_inventory.service_level
		ON 	dwh_capacity.service_level_dimension.id = dwh_inventory.service_level.id
		GROUP BY
			Tier,
			dwh_capacity.date_dimension.fullDate
		) total
	) Y</sqlText>
		<mdProjectedItems><mdProjectedItem name="Total Provisioned (TB)"/><mdProjectedItem name="Total Provisioned (TB) Last Month"/><mdProjectedItem name="Change in Total Provisioned (TB)"/><mdProjectedItem name="Percent Change in Total Provisioned (TB)"/><mdProjectedItem name="Total Provisioned Cost"/><mdProjectedItem name="Total Provisioned Cost Last Month"/><mdProjectedItem name="Change in Total Provisioned Cost"/><mdProjectedItem name="Percent Change in Total Provisioned Cost"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Total Provisioned (TB)"><expression>[SQL1].[Total Provisioned (TB)]</expression></dataItem><dataItem name="Total Provisioned (TB) Last Month"><expression>[SQL1].[Total Provisioned (TB) Last Month]</expression></dataItem><dataItem name="Change in Total Provisioned (TB)"><expression>[SQL1].[Change in Total Provisioned (TB)]</expression></dataItem><dataItem name="Percent Change in Total Provisioned (TB)"><expression>[SQL1].[Percent Change in Total Provisioned (TB)]</expression></dataItem><dataItem name="Total Provisioned Cost"><expression>IF([SQL1].[Total Provisioned Cost] &gt; 1000000) THEN ([SQL1].[Total Provisioned Cost]/1000/1000) ELSE ([SQL1].[Total Provisioned Cost])</expression></dataItem><dataItem name="Total Provisioned Cost Last Month"><expression>[SQL1].[Total Provisioned Cost Last Month]</expression></dataItem><dataItem name="Change in Total Provisioned Cost"><expression>[SQL1].[Change in Total Provisioned Cost]</expression></dataItem><dataItem name="Percent Change in Total Provisioned Cost"><expression>[SQL1].[Percent Change in Total Provisioned Cost]</expression></dataItem></selection>
		</query><query name="Tier or Service Level Data"><source><sqlQuery name="SQL2" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT

CASE 	
WHEN 	
dwh_capacity.service_level_dimension.tk = 0
THEN 	dwh_capacity.tier_dimension.name
ELSE 	dwh_capacity.service_level_dimension.name
END 	AS 	'Tier',

CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
THEN 	dwh_inventory.tier.cost
ELSE 	dwh_inventory.service_level.cost
END 	AS 	'Tier Cost'

		FROM 	dwh_capacity.chargeback_fact
		JOIN 	dwh_capacity.service_level_dimension
		ON 	dwh_capacity.chargeback_fact.serviceLevelTk = dwh_capacity.service_level_dimension.tk
		AND 	dwh_capacity.chargeback_fact.mappedByVM = 0
		JOIN 	dwh_capacity.tier_dimension
		ON 	dwh_capacity.chargeback_fact.tierTk = dwh_capacity.tier_dimension.tk
		JOIN 	dwh_capacity.date_dimension
		ON 	dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk
		AND 	dwh_capacity.date_dimension.latest = 1
		JOIN 	dwh_inventory.tier
		ON 	dwh_capacity.tier_dimension.id = dwh_inventory.tier.id
		JOIN 	dwh_inventory.service_level
		ON 	dwh_capacity.service_level_dimension.id = dwh_inventory.service_level.id
				
		GROUP BY
			Tier
			
</sqlText>
		<mdProjectedItems><mdProjectedItem name="Tier"/><mdProjectedItem name="Tier Cost"/></mdProjectedItems></sqlQuery></source><selection><dataItem name="Tier"><expression>[SQL2].[Tier]</expression></dataItem><dataItem name="Tier Cost"><expression>[SQL2].[Tier Cost]</expression></dataItem></selection></query><query name="Top 5 Business Units">
			<source>
				
			<sqlQuery name="SQL3" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT 	
        x.Tenant as 'Tenant',
        x.LineofBusiness as 'Line of Business',
        x.BusinessUnit as 'Business Unit',
        x.Project as 'Project',
        x.Application as 'Application',
        x.Host as 'Host',
        IF(x.OS LIKE CONCAT('%','Windows','%'), 'Windows', 
        IF(x.OS LIKE CONCAT('%','Linux','%'), 'Linux', null )) as 'OS', 
                  
        x.Type as 'Host Type',
        x.Processors as 'Processors',
 

CASE 
	WHEN x.Processors=1 THEN 't2.small'
	WHEN x.Processors&lt;=2 THEN 'm4.large'
	WHEN x.Processors&lt;=4 THEN 'm4.xlarge'
	WHEN x.Processors&lt;=8 THEN 'm4.2xlarge'
	WHEN x.Processors&lt;=16 THEN 'm4.4xlarge'
	WHEN x.Processors&lt;=40 THEN 'm4.10xlarge'            
	ELSE IF(x.Processors is null, null, 'm4.16xlarge')
        END AS 'ConfiguredAs',


       x.Memory as 'Memory',
        x.provTB AS 'Total Provisioned (TB)',
        x.provGB as 'Total Provisioned (GB)',
		SUM(x.cost) AS 'Total Provisioned Cost',
		
		IF(x.Type='Physical', SUM(x.cost), 0) as 'Physical Compute Cost',
	IF(x.Type='Virtual', SUM(x.cost), 0) as 'Virtual Compute Cost'
	
FROM 	(
	SELECT 	
	
	        total.Tenant,
	        total.LineofBusiness,
	        total.BusinessUnit,
	        total.Project,
	        total.Application,
	        total.Host as 'Host',
	        total.OS as 'OS',
	        total.Type as 'Type',
	        total.Processors as 'Processors',
	        total.memory as 'Memory',
	        SUM(total.provTB) AS provTB,
	        SUM(total.provGB) as provGB,
		SUM(total.cost) AS cost
	FROM 	(
		SELECT 	
		
		dwh_capacity.business_entity_dimension.tenant AS 'Tenant',
                dwh_capacity.business_entity_dimension.lob AS 'LineofBusiness',
                dwh_capacity.business_entity_dimension.businessUnit AS 'BusinessUnit',
                dwh_capacity.business_entity_dimension.project AS 'Project',
                dwh_capacity.application_dimension.name AS 'Application',

		dwh_capacity.host_dimension.name as 'Host',
		null as 'OS',
		null as 'Processors',
		null as 'Memory',
		
		'Physical' as 'Type',

		CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	dwh_capacity.tier_dimension.name
				ELSE 	dwh_capacity.service_level_dimension.name
			END 	AS 	tier,
			CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	dwh_inventory.tier.cost
				ELSE 	dwh_inventory.service_level.cost
			END 	AS 	tierPerGB,
			dwh_capacity.date_dimension.fullDate AS fullDate,
			ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024/1024,2) AS provTB,
			ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) AS provGB,
			
			CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	ROUND(ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) * dwh_inventory.tier.cost, 2)
				ELSE 	ROUND(ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) * dwh_inventory.service_level.cost, 2)
			END 	AS 	cost
		FROM 	dwh_capacity.chargeback_fact
		JOIN 	dwh_capacity.service_level_dimension
		ON 	dwh_capacity.chargeback_fact.serviceLevelTk = dwh_capacity.service_level_dimension.tk
		AND 	dwh_capacity.chargeback_fact.mappedByVM = 0
		JOIN 	dwh_capacity.tier_dimension
		ON 	dwh_capacity.chargeback_fact.tierTk = dwh_capacity.tier_dimension.tk
		JOIN 	dwh_capacity.date_dimension
		ON 	dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk
		AND 	dwh_capacity.date_dimension.latest = 1
		JOIN 	dwh_inventory.tier
		ON 	dwh_capacity.tier_dimension.id = dwh_inventory.tier.id
		JOIN 	dwh_inventory.service_level
		ON 	dwh_capacity.service_level_dimension.id = dwh_inventory.service_level.id
		LEFT JOIN    dwh_capacity.business_entity_dimension
		ON      dwh_capacity.business_entity_dimension.tk=dwh_capacity.chargeback_fact.businessentitytk
		LEFT JOIN    dwh_capacity.application_dimension
		ON           dwh_capacity.application_dimension.tk=dwh_capacity.chargeback_fact.applicationtk
		LEFT JOIN    dwh_capacity.host_dimension
		ON           dwh_capacity.host_dimension.tk=dwh_capacity.chargeback_fact.hosttk
		
		GROUP BY
			Tier, Host,
			dwh_capacity.date_dimension.fullDate
		UNION
		SELECT 	

                dwh_capacity.business_entity_dimension.tenant AS 'Tenant',
                dwh_capacity.business_entity_dimension.lob AS 'LineofBusiness',
                dwh_capacity.business_entity_dimension.businessUnit AS 'BusinessUnit',
                dwh_capacity.business_entity_dimension.project AS 'Project',
                dwh_capacity.application_dimension.name AS 'Application',

		dwh_capacity.vm_dimension.name as 'Host',
		dwh_capacity.vm_dimension.os as 'OS',
		(SELECT dwh_inventory.hv_virtual_machine.processors FROM dwh_inventory.hv_virtual_machine 
		WHERE dwh_inventory.hv_virtual_machine.id=dwh_capacity.vm_dimension.id) as 'Processors',
		
		(SELECT dwh_inventory.hv_virtual_machine.memory FROM dwh_inventory.hv_virtual_machine 
		WHERE dwh_inventory.hv_virtual_machine.id=dwh_capacity.vm_dimension.id) as 'Memory',
		
		'Virtual' as 'Type',
		
		CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	dwh_capacity.tier_dimension.name
				ELSE 	dwh_capacity.service_level_dimension.name
			END 	AS 	tier,
			CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	dwh_inventory.tier.cost
				ELSE 	dwh_inventory.service_level.cost
			END 	AS 	tierPerGB,
			dwh_capacity.date_dimension.fullDate AS fullDate,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024/1024,2) AS provTB,
                        ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024,2) AS provGB,
			CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	ROUND(ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024,2) * dwh_inventory.tier.cost, 2)
				ELSE 	ROUND(ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024,2) * dwh_inventory.service_level.cost, 2)
			END 	AS 	cost
		FROM 	dwh_capacity.vm_capacity_fact
		JOIN 	dwh_capacity.service_level_dimension
		ON 	dwh_capacity.vm_capacity_fact.serviceLevelTk = dwh_capacity.service_level_dimension.tk
		JOIN 	dwh_capacity.tier_dimension
		ON 	dwh_capacity.vm_capacity_fact.tierTk = dwh_capacity.tier_dimension.tk
		JOIN 	dwh_capacity.date_dimension
		ON 	dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
		AND 	dwh_capacity.date_dimension.latest = 1
		LEFT JOIN 	dwh_inventory.tier
		ON 	dwh_capacity.tier_dimension.id = dwh_inventory.tier.id
		LEFT JOIN 	dwh_inventory.service_level
		ON 	dwh_capacity.service_level_dimension.id = dwh_inventory.service_level.id
		LEFT JOIN    dwh_capacity.business_entity_dimension
		ON      dwh_capacity.business_entity_dimension.tk=dwh_capacity.vm_capacity_fact.businessentitytk
		LEFT JOIN    dwh_capacity.application_dimension
		ON           dwh_capacity.application_dimension.tk=dwh_capacity.vm_capacity_fact.applicationtk
		LEFT JOIN    dwh_capacity.vm_dimension
		ON           dwh_capacity.vm_dimension.tk=dwh_capacity.vm_capacity_fact.vmtk
		
		GROUP BY
			Tier, Host,
			dwh_capacity.date_dimension.fullDate
		) total
	GROUP BY businessunit
	
	) X
	
	GROUP BY x.businessunit 


	</sqlText>
		<mdProjectedItems><mdProjectedItem name="Tenant"/><mdProjectedItem name="Line of Business"/><mdProjectedItem name="Business Unit"/><mdProjectedItem name="Project"/><mdProjectedItem name="Application"/><mdProjectedItem name="Host"/><mdProjectedItem name="OS"/><mdProjectedItem name="Host Type"/><mdProjectedItem name="Processors"/><mdProjectedItem name="ConfiguredAs"/><mdProjectedItem name="Memory"/><mdProjectedItem name="Total Provisioned (TB)"/><mdProjectedItem name="Total Provisioned (GB)"/><mdProjectedItem name="Total Provisioned Cost"/><mdProjectedItem name="Physical Compute Cost"/><mdProjectedItem name="Virtual Compute Cost"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Business Unit"><expression>[SQL3].[Business Unit]</expression></dataItem><dataItem name="Total Provisioned Cost" aggregate="total"><expression>[SQL3].[Total Provisioned Cost]/1000</expression></dataItem><dataItem name="rank"><expression>rank([Total Provisioned Cost])</expression></dataItem></selection>
		<detailFilters><detailFilter><filterExpression>[Business Unit]&lt;&gt; 'N/A'</filterExpression></detailFilter><detailFilter postAutoAggregation="true"><filterExpression>[rank] &lt; 6</filterExpression></detailFilter></detailFilters></query><query name="Top 5 Applications">
			<source>
				
			<sqlQuery name="SQL4" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT 	
               x.Application as 'Application',
      SUM(x.cost) AS 'Total Provisioned Cost'
		

FROM 	(
	SELECT 	
	
	        total.Tenant,
	        total.LineofBusiness,
	        total.BusinessUnit,
	        total.Project,
	        total.Application,
	        total.Host as 'Host',
	        total.OS as 'OS',
	        total.Type as 'Type',
	        total.Processors as 'Processors',
	        total.memory as 'Memory',
	        SUM(total.provTB) AS provTB,
	        SUM(total.provGB) as provGB,
		SUM(total.cost) AS cost
	FROM 	(
		SELECT 	
		
		dwh_capacity.business_entity_dimension.tenant AS 'Tenant',
                dwh_capacity.business_entity_dimension.lob AS 'LineofBusiness',
                dwh_capacity.business_entity_dimension.businessUnit AS 'BusinessUnit',
                dwh_capacity.business_entity_dimension.project AS 'Project',
                dwh_capacity.application_dimension.name AS 'Application',

		dwh_capacity.host_dimension.name as 'Host',
		null as 'OS',
		null as 'Processors',
		null as 'Memory',
		
		'Physical' as 'Type',

		CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	dwh_capacity.tier_dimension.name
				ELSE 	dwh_capacity.service_level_dimension.name
			END 	AS 	tier,
			CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	dwh_inventory.tier.cost
				ELSE 	dwh_inventory.service_level.cost
			END 	AS 	tierPerGB,
			dwh_capacity.date_dimension.fullDate AS fullDate,
			ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024/1024,2) AS provTB,
			ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) AS provGB,
			
			CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	ROUND(ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) * dwh_inventory.tier.cost, 2)
				ELSE 	ROUND(ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) * dwh_inventory.service_level.cost, 2)
			END 	AS 	cost
		FROM 	dwh_capacity.chargeback_fact
		JOIN 	dwh_capacity.service_level_dimension
		ON 	dwh_capacity.chargeback_fact.serviceLevelTk = dwh_capacity.service_level_dimension.tk
		AND 	dwh_capacity.chargeback_fact.mappedByVM = 0
		JOIN 	dwh_capacity.tier_dimension
		ON 	dwh_capacity.chargeback_fact.tierTk = dwh_capacity.tier_dimension.tk
		JOIN 	dwh_capacity.date_dimension
		ON 	dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk
		AND 	dwh_capacity.date_dimension.latest = 1
		JOIN 	dwh_inventory.tier
		ON 	dwh_capacity.tier_dimension.id = dwh_inventory.tier.id
		JOIN 	dwh_inventory.service_level
		ON 	dwh_capacity.service_level_dimension.id = dwh_inventory.service_level.id
		LEFT JOIN    dwh_capacity.business_entity_dimension
		ON      dwh_capacity.business_entity_dimension.tk=dwh_capacity.chargeback_fact.businessentitytk
		LEFT JOIN    dwh_capacity.application_dimension
		ON           dwh_capacity.application_dimension.tk=dwh_capacity.chargeback_fact.applicationtk
AND	dwh_capacity.application_dimension.name NOT LIKE CONCAT('%','Allegiant','%')

		LEFT JOIN    dwh_capacity.host_dimension
		ON           dwh_capacity.host_dimension.tk=dwh_capacity.chargeback_fact.hosttk
		
		GROUP BY
			Tier, Host,
			dwh_capacity.date_dimension.fullDate
		UNION
		SELECT 	

                dwh_capacity.business_entity_dimension.tenant AS 'Tenant',
                dwh_capacity.business_entity_dimension.lob AS 'LineofBusiness',
                dwh_capacity.business_entity_dimension.businessUnit AS 'BusinessUnit',
                dwh_capacity.business_entity_dimension.project AS 'Project',
                dwh_capacity.application_dimension.name AS 'Application',

		dwh_capacity.vm_dimension.name as 'Host',
		dwh_capacity.vm_dimension.os as 'OS',
		(SELECT dwh_inventory.hv_virtual_machine.processors FROM dwh_inventory.hv_virtual_machine 
		WHERE dwh_inventory.hv_virtual_machine.id=dwh_capacity.vm_dimension.id) as 'Processors',
		
		(SELECT dwh_inventory.hv_virtual_machine.memory FROM dwh_inventory.hv_virtual_machine 
		WHERE dwh_inventory.hv_virtual_machine.id=dwh_capacity.vm_dimension.id) as 'Memory',
		
		'Virtual' as 'Type',
		
		CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	dwh_capacity.tier_dimension.name
				ELSE 	dwh_capacity.service_level_dimension.name
			END 	AS 	tier,
			CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	dwh_inventory.tier.cost
				ELSE 	dwh_inventory.service_level.cost
			END 	AS 	tierPerGB,
			dwh_capacity.date_dimension.fullDate AS fullDate,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024/1024,2) AS provTB,
                        ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024,2) AS provGB,
			CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	ROUND(ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024,2) * dwh_inventory.tier.cost, 2)
				ELSE 	ROUND(ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024,2) * dwh_inventory.service_level.cost, 2)
			END 	AS 	cost
		FROM 	dwh_capacity.vm_capacity_fact
		JOIN 	dwh_capacity.service_level_dimension
		ON 	dwh_capacity.vm_capacity_fact.serviceLevelTk = dwh_capacity.service_level_dimension.tk
		JOIN 	dwh_capacity.tier_dimension
		ON 	dwh_capacity.vm_capacity_fact.tierTk = dwh_capacity.tier_dimension.tk
		JOIN 	dwh_capacity.date_dimension
		ON 	dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
		AND 	dwh_capacity.date_dimension.latest = 1
		LEFT JOIN 	dwh_inventory.tier
		ON 	dwh_capacity.tier_dimension.id = dwh_inventory.tier.id
		LEFT JOIN 	dwh_inventory.service_level
		ON 	dwh_capacity.service_level_dimension.id = dwh_inventory.service_level.id
		LEFT JOIN    dwh_capacity.business_entity_dimension
		ON      dwh_capacity.business_entity_dimension.tk=dwh_capacity.vm_capacity_fact.businessentitytk
		LEFT JOIN    dwh_capacity.application_dimension
		ON           dwh_capacity.application_dimension.tk=dwh_capacity.vm_capacity_fact.applicationtk
AND	dwh_capacity.application_dimension.name NOT LIKE CONCAT('%','Allegiant','%')
		LEFT JOIN    dwh_capacity.vm_dimension
		ON           dwh_capacity.vm_dimension.tk=dwh_capacity.vm_capacity_fact.vmtk
		
		GROUP BY
			Tier, Host,
			dwh_capacity.date_dimension.fullDate
		) total
	GROUP BY Application
	
	) X
	
	GROUP BY x.Application


	</sqlText>
		<mdProjectedItems><mdProjectedItem name="Application"/><mdProjectedItem name="Total Provisioned Cost"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Application"><expression>[SQL4].[Application]</expression></dataItem><dataItem name="Total Provisioned Cost" aggregate="total"><expression>[SQL4].[Total Provisioned Cost]/1000</expression></dataItem><dataItem name="rank"><expression>rank([Total Provisioned Cost])</expression></dataItem></selection>
		<detailFilters><detailFilter><filterExpression>[Application]&lt;&gt;'N/A'</filterExpression></detailFilter><detailFilter postAutoAggregation="true"><filterExpression>[rank]&lt;6</filterExpression></detailFilter></detailFilters></query><query name="Top 5 Hosts">
			<source>
				
			<sqlQuery name="SQL5" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT 	
        x.Tenant as 'Tenant',
        x.LineofBusiness as 'Line of Business',
        x.BusinessUnit as 'Business Unit',
        x.Project as 'Project',
        x.Application as 'Application',
        x.Host as 'Host',
        IF(x.OS LIKE CONCAT('%','Windows','%'), 'Windows', 
        IF(x.OS LIKE CONCAT('%','Linux','%'), 'Linux', null )) as 'OS', 
                  
        x.Type as 'Host Type',
        x.Processors as 'Processors',
 

CASE 
	WHEN x.Processors=1 THEN 't2.small'
	WHEN x.Processors&lt;=2 THEN 'm4.large'
	WHEN x.Processors&lt;=4 THEN 'm4.xlarge'
	WHEN x.Processors&lt;=8 THEN 'm4.2xlarge'
	WHEN x.Processors&lt;=16 THEN 'm4.4xlarge'
	WHEN x.Processors&lt;=40 THEN 'm4.10xlarge'            
	ELSE IF(x.Processors is null, null, 'm4.16xlarge')
        END AS 'ConfiguredAs',


       x.Memory as 'Memory',
        x.provTB AS 'Total Provisioned (TB)',
        x.provGB as 'Total Provisioned (GB)',
		SUM(x.cost) AS 'Total Provisioned Cost',
		
		IF(x.Type='Physical', SUM(x.cost), 0) as 'Physical Compute Cost',
	IF(x.Type='Virtual', SUM(x.cost), 0) as 'Virtual Compute Cost'
	
FROM 	(
	SELECT 	
	
	        total.Tenant,
	        total.LineofBusiness,
	        total.BusinessUnit,
	        total.Project,
	        total.Application,
	        total.Host as 'Host',
	        total.OS as 'OS',
	        total.Type as 'Type',
	        total.Processors as 'Processors',
	        total.memory as 'Memory',
	        SUM(total.provTB) AS provTB,
	        SUM(total.provGB) as provGB,
		SUM(total.cost) AS cost
	FROM 	(
		SELECT 	
		
		dwh_capacity.business_entity_dimension.tenant AS 'Tenant',
                dwh_capacity.business_entity_dimension.lob AS 'LineofBusiness',
                dwh_capacity.business_entity_dimension.businessUnit AS 'BusinessUnit',
                dwh_capacity.business_entity_dimension.project AS 'Project',
                dwh_capacity.application_dimension.name AS 'Application',

		dwh_capacity.host_dimension.name as 'Host',
		null as 'OS',
		null as 'Processors',
		null as 'Memory',
		
		'Physical' as 'Type',

		CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	dwh_capacity.tier_dimension.name
				ELSE 	dwh_capacity.service_level_dimension.name
			END 	AS 	tier,
			CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	dwh_inventory.tier.cost
				ELSE 	dwh_inventory.service_level.cost
			END 	AS 	tierPerGB,
			dwh_capacity.date_dimension.fullDate AS fullDate,
			ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024/1024,2) AS provTB,
			ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) AS provGB,
			
			CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	ROUND(ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) * dwh_inventory.tier.cost, 2)
				ELSE 	ROUND(ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) * dwh_inventory.service_level.cost, 2)
			END 	AS 	cost
		FROM 	dwh_capacity.chargeback_fact
		JOIN 	dwh_capacity.service_level_dimension
		ON 	dwh_capacity.chargeback_fact.serviceLevelTk = dwh_capacity.service_level_dimension.tk
		AND 	dwh_capacity.chargeback_fact.mappedByVM = 0
		JOIN 	dwh_capacity.tier_dimension
		ON 	dwh_capacity.chargeback_fact.tierTk = dwh_capacity.tier_dimension.tk
		JOIN 	dwh_capacity.date_dimension
		ON 	dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk
		AND 	dwh_capacity.date_dimension.latest = 1
		JOIN 	dwh_inventory.tier
		ON 	dwh_capacity.tier_dimension.id = dwh_inventory.tier.id
		JOIN 	dwh_inventory.service_level
		ON 	dwh_capacity.service_level_dimension.id = dwh_inventory.service_level.id
		LEFT JOIN    dwh_capacity.business_entity_dimension
		ON      dwh_capacity.business_entity_dimension.tk=dwh_capacity.chargeback_fact.businessentitytk
		LEFT JOIN    dwh_capacity.application_dimension
		ON           dwh_capacity.application_dimension.tk=dwh_capacity.chargeback_fact.applicationtk
		LEFT JOIN    dwh_capacity.host_dimension
		ON           dwh_capacity.host_dimension.tk=dwh_capacity.chargeback_fact.hosttk
		
		GROUP BY
			Tier, Host,
			dwh_capacity.date_dimension.fullDate
		UNION
		SELECT 	

                dwh_capacity.business_entity_dimension.tenant AS 'Tenant',
                dwh_capacity.business_entity_dimension.lob AS 'LineofBusiness',
                dwh_capacity.business_entity_dimension.businessUnit AS 'BusinessUnit',
                dwh_capacity.business_entity_dimension.project AS 'Project',
                dwh_capacity.application_dimension.name AS 'Application',

		dwh_capacity.vm_dimension.name as 'Host',
		dwh_capacity.vm_dimension.os as 'OS',
		(SELECT dwh_inventory.hv_virtual_machine.processors FROM dwh_inventory.hv_virtual_machine 
		WHERE dwh_inventory.hv_virtual_machine.id=dwh_capacity.vm_dimension.id) as 'Processors',
		
		(SELECT dwh_inventory.hv_virtual_machine.memory FROM dwh_inventory.hv_virtual_machine 
		WHERE dwh_inventory.hv_virtual_machine.id=dwh_capacity.vm_dimension.id) as 'Memory',
		
		'Virtual' as 'Type',
		
		CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	dwh_capacity.tier_dimension.name
				ELSE 	dwh_capacity.service_level_dimension.name
			END 	AS 	tier,
			CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	dwh_inventory.tier.cost
				ELSE 	dwh_inventory.service_level.cost
			END 	AS 	tierPerGB,
			dwh_capacity.date_dimension.fullDate AS fullDate,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024/1024,2) AS provTB,
                        ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024,2) AS provGB,
			CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	ROUND(ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024,2) * dwh_inventory.tier.cost, 2)
				ELSE 	ROUND(ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024,2) * dwh_inventory.service_level.cost, 2)
			END 	AS 	cost
		FROM 	dwh_capacity.vm_capacity_fact
		JOIN 	dwh_capacity.service_level_dimension
		ON 	dwh_capacity.vm_capacity_fact.serviceLevelTk = dwh_capacity.service_level_dimension.tk
		JOIN 	dwh_capacity.tier_dimension
		ON 	dwh_capacity.vm_capacity_fact.tierTk = dwh_capacity.tier_dimension.tk
		JOIN 	dwh_capacity.date_dimension
		ON 	dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
		AND 	dwh_capacity.date_dimension.latest = 1
		LEFT JOIN 	dwh_inventory.tier
		ON 	dwh_capacity.tier_dimension.id = dwh_inventory.tier.id
		LEFT JOIN 	dwh_inventory.service_level
		ON 	dwh_capacity.service_level_dimension.id = dwh_inventory.service_level.id
		LEFT JOIN    dwh_capacity.business_entity_dimension
		ON      dwh_capacity.business_entity_dimension.tk=dwh_capacity.vm_capacity_fact.businessentitytk
		LEFT JOIN    dwh_capacity.application_dimension
		ON           dwh_capacity.application_dimension.tk=dwh_capacity.vm_capacity_fact.applicationtk
		LEFT JOIN    dwh_capacity.vm_dimension
		ON           dwh_capacity.vm_dimension.tk=dwh_capacity.vm_capacity_fact.vmtk
		
		GROUP BY
			Tier, Host,
			dwh_capacity.date_dimension.fullDate
		) total
	GROUP BY Host
	
	) X
	
	GROUP BY Host
	
</sqlText>
		<mdProjectedItems><mdProjectedItem name="Tenant"/><mdProjectedItem name="Line of Business"/><mdProjectedItem name="Business Unit"/><mdProjectedItem name="Project"/><mdProjectedItem name="Application"/><mdProjectedItem name="Host"/><mdProjectedItem name="OS"/><mdProjectedItem name="Host Type"/><mdProjectedItem name="Processors"/><mdProjectedItem name="ConfiguredAs"/><mdProjectedItem name="Memory"/><mdProjectedItem name="Total Provisioned (TB)"/><mdProjectedItem name="Total Provisioned (GB)"/><mdProjectedItem name="Total Provisioned Cost"/><mdProjectedItem name="Physical Compute Cost"/><mdProjectedItem name="Virtual Compute Cost"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Tenant"><expression>[SQL5].[Tenant]</expression></dataItem><dataItem name="Line of Business"><expression>[SQL5].[Line of Business]</expression></dataItem><dataItem name="Business Unit"><expression>[SQL5].[Business Unit]</expression></dataItem><dataItem name="Project"><expression>[SQL5].[Project]</expression></dataItem><dataItem name="Application"><expression>[SQL5].[Application]</expression></dataItem><dataItem name="Host"><expression>[SQL5].[Host]</expression></dataItem><dataItem name="OS"><expression>[SQL5].[OS]</expression></dataItem><dataItem name="Host Type"><expression>[SQL5].[Host Type]</expression></dataItem><dataItem name="Processors"><expression>[SQL5].[Processors]</expression></dataItem><dataItem name="ConfiguredAs"><expression>[SQL5].[ConfiguredAs]</expression></dataItem><dataItem name="Memory"><expression>[SQL5].[Memory]</expression></dataItem><dataItem name="Total Provisioned (TB)"><expression>[SQL5].[Total Provisioned (TB)]</expression></dataItem><dataItem name="Total Provisioned (GB)"><expression>[SQL5].[Total Provisioned (GB)]</expression></dataItem><dataItem name="Total Provisioned Cost" aggregate="total"><expression>[SQL5].[Total Provisioned Cost]/1000</expression></dataItem><dataItem name="Physical Compute Cost"><expression>[SQL5].[Physical Compute Cost]</expression></dataItem><dataItem name="Virtual Compute Cost"><expression>[SQL5].[Virtual Compute Cost]</expression></dataItem><dataItem name="rank"><expression>rank([Total Provisioned Cost])</expression></dataItem></selection>
		<detailFilters><detailFilter><filterExpression>[Host]&lt;&gt;'N/A'</filterExpression></detailFilter><detailFilter postAutoAggregation="true"><filterExpression>[rank]&lt;6</filterExpression></detailFilter></detailFilters></query><query name="Chargeback Trending">
			<source>
				
			<sqlQuery dataSource="dwh_capacity" name="SQL2" type="passThrough">
			<sqlText>SELECT 	x.fullDate AS 'Date',
	SUM(x.allocatedTB) AS 'Allocated (TB)',
	SUM(x.cost) AS 'Allocated Cost'
FROM 	(
	SELECT 	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
			THEN 	dwh_capacity.tier_dimension.name
			ELSE 	dwh_capacity.service_level_dimension.name
		END 	AS 	Tier,
		CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
			THEN 	dwh_inventory.tier.cost
			ELSE 	dwh_inventory.service_level.cost
		END 	AS 	'Tier Cost/GB',
		dwh_capacity.date_dimension.fullDate AS fullDate,
		ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024/1024,2) AS allocatedTB,
		CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
			THEN 	ROUND(ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) * dwh_inventory.tier.cost, 2)
			ELSE 	ROUND(ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) * dwh_inventory.service_level.cost, 2)
		END 	AS 	cost
	FROM 	dwh_capacity.chargeback_fact
	JOIN 	dwh_capacity.service_level_dimension
	ON 	dwh_capacity.chargeback_fact.serviceLevelTk = dwh_capacity.service_level_dimension.tk
	AND 	dwh_capacity.chargeback_fact.mappedByVM = 0
	JOIN 	dwh_capacity.tier_dimension
	ON 	dwh_capacity.chargeback_fact.tierTk = dwh_capacity.tier_dimension.tk
	JOIN 	dwh_capacity.date_dimension
	ON 	dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk
	AND 	dwh_capacity.date_dimension.repMonthOrLatest = 1
	LEFT JOIN 	dwh_inventory.tier
	ON 	dwh_capacity.tier_dimension.id = dwh_inventory.tier.id
	LEFT JOIN 	dwh_inventory.service_level
	ON 	dwh_capacity.service_level_dimension.id = dwh_inventory.service_level.id
	
WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
FROM dwh_capacity.date_dimension JOIN  dwh_capacity.chargeback_fact 
ON  dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 12 MONTH


	GROUP BY
		Tier,
		dwh_capacity.date_dimension.fullDate
	UNION
	SELECT 	CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
			THEN 	dwh_capacity.tier_dimension.name
			ELSE 	dwh_capacity.service_level_dimension.name
		END 	AS 	Tier,
		CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
			THEN 	dwh_inventory.tier.cost
			ELSE 	dwh_inventory.service_level.cost
		END 	AS 	'Tier Cost/GB',
		dwh_capacity.date_dimension.fullDate AS fullDate,
		ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024/1024,2) AS allocatedTB,
		CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
			THEN 	ROUND(ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024,2) * dwh_inventory.tier.cost, 2)
			ELSE 	ROUND(ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024,2) * dwh_inventory.service_level.cost, 2)
		END 	AS 	cost
	FROM 	dwh_capacity.vm_capacity_fact
	JOIN 	dwh_capacity.service_level_dimension
	ON 	dwh_capacity.vm_capacity_fact.serviceLevelTk = dwh_capacity.service_level_dimension.tk
	JOIN 	dwh_capacity.tier_dimension
	ON 	dwh_capacity.vm_capacity_fact.tierTk = dwh_capacity.tier_dimension.tk
	JOIN 	dwh_capacity.date_dimension
	ON 	dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
	AND 	dwh_capacity.date_dimension.repMonthOrLatest = 1
	LEFT JOIN 	dwh_inventory.tier
	ON 	dwh_capacity.tier_dimension.id = dwh_inventory.tier.id
	LEFT JOIN 	dwh_inventory.service_level
	ON 	dwh_capacity.service_level_dimension.id = dwh_inventory.service_level.id
	
WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
FROM dwh_capacity.date_dimension JOIN  dwh_capacity.vm_capacity_fact 
ON  dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 12 MONTH



	GROUP BY
		Tier,
		dwh_capacity.date_dimension.fullDate
	) X
GROUP BY
	x.fullDate</sqlText>
		<mdProjectedItems><mdProjectedItem name="Date"/><mdProjectedItem name="Allocated (TB)"/><mdProjectedItem name="Allocated Cost"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Date"><expression>[SQL2].[Date]</expression></dataItem><dataItem aggregate="total" name="Allocated (TB)"><expression>[SQL2].[Allocated (TB)]</expression></dataItem><dataItem aggregate="total" name="Allocated Cost"><expression>[SQL2].[Allocated Cost]/1000</expression></dataItem></selection>
		</query><query name="Cost per IOpS Trends">
			<source>
				
			<sqlQuery name="SQL9" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT     
    diskPerf.datacenter as 'DataCenter',
    diskPerf.array as 'Array',
	diskPerf.poolname as 'PoolName',
    diskPerf.disk as 'DiskName',   
    diskPerf.Tier as 'Tier',
    diskPerf.Cost as 'Cost',
    diskPerf.DiskCapacityGB as 'Capacity GB',
    ROUND(diskPerf.totalIops,0) AS 'DiskIOPS',
  
	 diskPerf.poolIOpSCapability AS 'poolIOpSCapability',
	 
	ROUND( (diskPerf.Cost * diskPerf.DiskCapacityGB) / diskPerf.poolIOpSCapability ,2) as 'Cost per IOpS',

diskPerf.fulldate as 'Date'
	 
	 
	 

FROM    (
SELECT
    dwh_performance.storage_dimension.name as array,
    dwh_performance.storage_dimension.datacenter as datacenter,
	dwh_performance.storage_pool_dimension.name as poolname,
       dwh_inventory.disk.name as disk,
        IF(dwh_inventory.annotation_value.annotationtype='Tier', dwh_inventory.annotation_value.valueIdentifier, null) as 'Tier',
  IF(dwh_inventory.annotation_value.annotationtype='Tier', dwh_inventory.annotation_value.enumCost, null) as 'Cost',
        SUM(dwh_performance.disk_daily_performance_fact.totalIops) totalIops,
		SUM(dwh_performance.disk_daily_performance_fact.totalIopsmax) totalIopsmax,
        SUM(dwh_performance.disk_daily_performance_fact.readIops) readIops,
        SUM(dwh_performance.disk_daily_performance_fact.writeIops) writeIops,
        SUM(dwh_performance.disk_daily_performance_fact.totalThroughput) totalThroughput,
        SUM(dwh_performance.disk_daily_performance_fact.readThroughput) readThroughput,
        SUM(dwh_performance.disk_daily_performance_fact.writeThroughput) writeThroughput,
         dwh_performance.date_dimension.fulldate,
       
		
			COUNT(DISTINCT dwh_inventory.disk.id) AS 'diskCount',
				
			CASE
				WHEN MIN(CASE
					WHEN dwh_inventory.disk.type = 'SSD' THEN 4
					WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 15000 THEN 3
					WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 15000 THEN 3
					WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 10000 THEN 2
					WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 10000 THEN 2
					ELSE 1
					END) = 4 THEN 3000
				WHEN MIN(CASE
					WHEN dwh_inventory.disk.type = 'SSD' THEN 4
					WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 15000 THEN 3
					WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 15000 THEN 3
					WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 10000 THEN 2
					WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 10000 THEN 2
					ELSE 1
					END) = 3 THEN 200
				WHEN MIN(CASE
					WHEN dwh_inventory.disk.type = 'SSD' THEN 4
					WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 15000 THEN 3
					WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 15000 THEN 3
					WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 10000 THEN 2
					WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 10000 THEN 2
					ELSE 1
					END) = 2 THEN 170
				ELSE 75
			END AS 'diskIOpSCapability',
		
				COUNT(DISTINCT dwh_inventory.disk.id) *
				(CASE
					WHEN MIN(CASE
						WHEN dwh_inventory.disk.type = 'SSD' THEN 4
						WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 15000 THEN 3
						WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 15000 THEN 3
						WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 10000 THEN 2
						WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 10000 THEN 2
						ELSE 1
						END) = 4 THEN 3000
					WHEN MIN(CASE
						WHEN dwh_inventory.disk.type = 'SSD' THEN 4
						WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 15000 THEN 3
						WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 15000 THEN 3
						WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 10000 THEN 2
						WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 10000 THEN 2
						ELSE 1
						END) = 3 THEN 200
					WHEN MIN(CASE
						WHEN dwh_inventory.disk.type = 'SSD' THEN 4
						WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 15000 THEN 3
						WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 15000 THEN 3
						WHEN dwh_inventory.disk.type = 'SAS' AND dwh_inventory.disk.speed = 10000 THEN 2
						WHEN dwh_inventory.disk.type = 'FC' AND dwh_inventory.disk.speed = 10000 THEN 2
						ELSE 1
						END) = 2 THEN 170
					ELSE 75
				END ) AS 'poolIopsCapability',
               
			   CASE
					WHEN MIN(CASE
						WHEN dwh_inventory.disk.type = 'SSD' THEN 4
						WHEN dwh_inventory.disk.type = 'SAS' THEN 3
						WHEN dwh_inventory.disk.type = 'FC'  THEN 2
                        WHEN dwh_inventory.disk.type LIKE '%SATA%' THEN 1
						ELSE 0
						END) = 4 THEN 'SSD'
					WHEN MIN(CASE
						WHEN dwh_inventory.disk.type = 'SSD' THEN 4
						WHEN dwh_inventory.disk.type = 'SAS' THEN 3
						WHEN dwh_inventory.disk.type = 'FC'  THEN 2
                        WHEN dwh_inventory.disk.type LIKE '%SATA%' THEN 1
						ELSE 0
						END) = 3 THEN 'SAS'
					WHEN MIN(CASE
						WHEN dwh_inventory.disk.type = 'SSD' THEN 4
						WHEN dwh_inventory.disk.type = 'SAS' THEN 3
						WHEN dwh_inventory.disk.type = 'FC' THEN 2
						WHEN dwh_inventory.disk.type LIKE '%SATA%' THEN 1
						ELSE 0
						END) = 2 THEN 'FC'
                     WHEN MIN(CASE
						WHEN dwh_inventory.disk.type = 'SSD' THEN 4
						WHEN dwh_inventory.disk.type = 'SAS' THEN 3
						WHEN dwh_inventory.disk.type = 'FC'  THEN 2
						WHEN dwh_inventory.disk.type LIKE '%SATA%' THEN 1
						ELSE 0
						END) = 1 THEN 'SATA'   
					ELSE 'Not Defined'
					END AS 'diskType',
                    MIN(dwh_inventory.disk.speed) AS 'diskSpeed',
					dwh_inventory.disk.capacityGB AS 'diskCapacityGB'
		
		
    FROM    dwh_performance.disk_daily_performance_fact
    JOIN    dwh_performance.storage_dimension
    ON  dwh_performance.disk_daily_performance_fact.storageTk = dwh_performance.storage_dimension.tk
    JOIN    dwh_performance.storage_pool_dimension
    ON  dwh_performance.disk_daily_performance_fact.storagePoolTk = dwh_performance.storage_pool_dimension.tk
    
    JOIN    dwh_performance.date_dimension
    ON  dwh_performance.disk_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk
    AND  dwh_performance.date_dimension.repmonthorlatest=1
    AND     dwh_performance.date_dimension.fullDate &gt;= (     SELECT  MAX(dwh_performance.date_dimension.fullDate)
                                FROM    dwh_performance.disk_daily_performance_fact
                                JOIN    dwh_performance.date_dimension
                                ON  dwh_performance.disk_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk ) - INTERVAL 12 MONTH
   
    JOIN    dwh_performance.disk_dimension
    ON  dwh_performance.disk_daily_performance_fact.diskTk = dwh_performance.disk_dimension.tk
    AND     dwh_performance.disk_dimension.role = 'DATA'
	JOIN  dwh_inventory.disk
	ON   dwh_inventory.disk.id=dwh_performance.disk_dimension.id
	JOIN dwh_inventory.storage_pool_to_disk
	ON   dwh_inventory.storage_pool_to_disk.diskid=dwh_inventory.disk.id
	JOIN dwh_inventory.storage_pool
	ON   dwh_inventory.storage_pool.id=dwh_inventory.storage_pool_to_disk.storagepoolid
	LEFT JOIN dwh_inventory.object_to_annotation
	ON   dwh_inventory.object_to_annotation.objectid=dwh_inventory.storage_pool.id
	LEFT JOIN dwh_inventory.annotation_value
	ON   dwh_inventory.annotation_value.id=dwh_inventory.object_to_annotation.annotationValueid
	
	
    GROUP BY
      dwh_inventory.disk.id,  dwh_performance.date_dimension.fulldate
      
       
    ) diskPerf</sqlText>
		<mdProjectedItems><mdProjectedItem name="DataCenter"/><mdProjectedItem name="Array"/><mdProjectedItem name="PoolName"/><mdProjectedItem name="DiskName"/><mdProjectedItem name="Tier"/><mdProjectedItem name="Cost"/><mdProjectedItem name="Capacity GB"/><mdProjectedItem name="DiskIOPS"/><mdProjectedItem name="poolIOpSCapability"/><mdProjectedItem name="Cost per IOpS"/><mdProjectedItem name="Date"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="DataCenter"><expression>[SQL9].[DataCenter]</expression></dataItem><dataItem name="Array"><expression>[SQL9].[Array]</expression></dataItem><dataItem name="PoolName"><expression>[SQL9].[PoolName]</expression></dataItem><dataItem name="DiskName"><expression>[SQL9].[DiskName]</expression></dataItem><dataItem name="Tier"><expression>[SQL9].[Tier]</expression></dataItem><dataItem name="Cost"><expression>[SQL9].[Cost]</expression></dataItem><dataItem name="Capacity GB"><expression>[SQL9].[Capacity GB]</expression></dataItem><dataItem name="DiskIOPS"><expression>[SQL9].[DiskIOPS]</expression></dataItem><dataItem name="poolIOpSCapability"><expression>[SQL9].[poolIOpSCapability]</expression></dataItem><dataItem name="Cost per IOpS" aggregate="average"><expression>[SQL9].[Cost per IOpS]</expression></dataItem><dataItem name="Date"><expression>[SQL9].[Date]</expression></dataItem></selection>
		</query></queries></report>